MrExcel Publishing
Your One Stop for Excel Tips & Solutions


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:


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