Vlookup / #name? error
That helped figure out my mistake.
Thank you.
Mukesh
"joel" wrote:
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
|