Vlookup formula not working

**DKAbi** · 11-27-2012, 09:43 AM

I have written a vlookup formula. I'd like the formula in column K to look at the category in column E, then look in sheet 2 and return the number that is next to the category there. The purpose is to measure target vs. actuals, but I can't get my vlookup formula to work. I have attached an example.

**Pete_UK** · 11-27-2012, 09:49 AM

I would suggest you re-write the formula in K2 like this:

=IF(ISERROR(VLOOKUP(E2,Sheet2!$A$1:$B$100,2,FALSE)),"","Match")

then copy down.

Hope this helps.

Pete

**TheExcelphile** · 11-27-2012, 09:55 AM

Hi!

Assuming you need the values instead of the word "Match", the formula I've used should work for you.

Don't forget to click the little star to the left of this post if you feel I helped!