VLOOKUP or INDEX & MATCH

Excel-Access

New member
Joined
Mar 13, 2014
Messages
2
Reaction score
0
Points
0
Could someone kindly inform me why neither my VLOOKUP or INDEX and MATCH is working

Thanks a million
 

Attachments

  • Index & Match.zip
    156.6 KB · Views: 12

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
The formats of Column A and E don't match.

You can either change column E to match, by selecting the column and going to Data|Text to Columns and simply clicking Finish.

Or account for the difference in the formulas:

e.g.

=VLOOKUP(""&A2,$E$2:$F$2300,2,FALSE)

and

=INDEX($F$2:$F$2300,(MATCH(""&A2,$E$2:$E$2300,0)))

The ""&A2 coerces the A2 to text format to match column E's text format.
 
Top