I get #name? error for this.... =VLOOKUP(A11, sheet2, A1:B26) Please help. Thanks. Mukesh
M Mukesh Apr 19, 2009 #1 I get #name? error for this.... =VLOOKUP(A11, sheet2, A1:B26) Please help. Thanks. Mukesh
J joel Apr 19, 2009 #2 the wrokshet function doesn't understand sheet2. by itself Sheet reference in the worksheet function require a sheet and a range sheet2!A1:B26 Now if you are looking for a string sheet2 then add the double quotes "sheet2"
the wrokshet function doesn't understand sheet2. by itself Sheet reference in the worksheet function require a sheet and a range sheet2!A1:B26 Now if you are looking for a string sheet2 then add the double quotes "sheet2"
