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" wrote:


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

=VLOOKUP(A11, sheet2, A1:B26)

Please help.

Thanks.
Mukesh