View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mukesh Mukesh is offline
external usenet poster
 
Posts: 78
Default 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