VLOOKUP not working

[Pasha81]

Hi guys, a VLOOKUP formula is not working , Im guessing its because the column its searching through has formulae in them

I need it to look at Cell Value instead of the formula in it.


On the sheet 'Detail' I have the VLOOKUP formula in Column Z, it looks through Column Y and categorizes it as (Oil, Agriculturals, etc which is done using a range from sheet IMAP)

How do I make the adjustment?

Thanks

[DonkeyOte]

The issue is more to do with the fundementals - ie a VLOOKUP looks left to right at all times - criteria must exist within leftmost column.

You need to use an INDEX/MATCH approach, ie:

=INDEX(IMAP!A:A,MATCH(Y2,IMAP!B:B,0))

[Pasha81]

Oh I see, thanks for explaining that. Because it was working when I used it to look left to right - confused me for a while.