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
