VLOOKUP or INDEX & MATCH

Could someone kindly inform me why neither my VLOOKUP or INDEX and MATCH is working

Thanks a million

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.

Excellent response

Thanks a million