Vlookup / #name? error

[Mukesh]

I get #name? error for this....

=VLOOKUP(A11, sheet2, A1:B26)

Please help.

Thanks.
Mukesh

 

[joel]

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"

 

[Mukesh]

That helped figure out my mistake.

Thank you.
Mukesh