ExcelBanter - Vlookup / #name? error

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Vlookup / #name? error (https://www.excelbanter.com/excel-discussion-misc-queries/228120-vlookup-name-error.html)

Mukesh

Vlookup / #name? error

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

=VLOOKUP(A11, sheet2, A1:B26)

Please help.

Thanks.
Mukesh

joel

Vlookup / #name? error

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

Mukesh

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

All times are GMT +1. The time now is 09:08 PM.