Vlookup not working

How come the yellow formulas don't work.

With Vlookup, the match has to occur in the left-most column of the table, and return from columns to the right.

Try this alternative:

=INDEX($E$18:$E$25,MATCH(A18,$F$18:$F$25,0))

copied down

Hi Xx7,

Is this a serious question? If so, what exactly -- in words -- are you trying to do?

Based on how VLOOKUP works, and the sample spreadsheet you provided, it appears you're trying to lookup the value in A18 in column E, and then return that value from column E. Something is amiss.

Are you actually trying to lookup the value in A18 in column F, and return the corresponding value from column E? If so, you can't use VLOOKUP as that only looks Left-to-Right. Instead try an INDEX/MATCH, e.g.

=INDEX($E$18:$E$25,MATCH(A18,$F$18:$F$25,0))

Hope that helps!