MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Vlookup


Posted by Kris Ibrahim on January 11, 2002 1:26 PM

I have a vlookup function and the look up cell does not seem to find the data from the Fjordungur(sheet1) I´m working in sheet3 (Bokun) and just get value error or name error no matter how I try to change the formula. HELP

The formula is =Vlookup(month(b2),fjordungar,2,true)


Posted by Aladin Akyurek on January 11, 2002 1:41 PM

Since you're using MONTH(B2) as lookup value, try an exact match:

=VLOOKUP(MONTH(B2),FJORDUNGAR,2,0)

where I assume FJORDUNGAR to be at least a 2-column table whose 1st column is populated with integers 1,2,... 12.

Aladin