vlookup with indirect
 

Hello again everyone


I have date in a sheet which I would like to refer to.

in A24 I have Setup!D5 which returns John Proud
in J24 I have =VLOOKUP(INDIRECT(A24),DB_list,2,FALSE)
which checks John Proud against a small array of names and a number in
cols a and b.
the result is #REF!

please can you explain this ??


Thanks

John Proud

vlookup with indirect
 

Tonto wrote:

It should be data not DATE Sorry

Hello again everyone


I have date in a sheet which I would like to refer to.

in A24 I have Setup!D5 which returns John Proud
in J24 I have =VLOOKUP(INDIRECT(A24),DB_list,2,FALSE)
which checks John Proud against a small array of names and a number in
cols a and b.
the result is #REF!

please can you explain this ??


Thanks

John Proud

vlookup with indirect
 

I'm not sure I understand the need for the "Indirect" function here. Try it
without.


"Tonto" wrote in message
oups.com...

Tonto wrote:

It should be data not DATE Sorry

Hello again everyone


I have date in a sheet which I would like to refer to.

in A24 I have Setup!D5 which returns John Proud
in J24 I have =VLOOKUP(INDIRECT(A24),DB_list,2,FALSE)
which checks John Proud against a small array of names and a number in
cols a and b.
the result is #REF!

please can you explain this ??


Thanks

John Proud

vlookup with indirect
 

Did that and it doesnt work.

Thanks

John

vlookup with indirect
 

Tonto wrote:

Did that and it doesnt work.

Thanks

John

SORTED

Setup was bringing an extra space between names.

Thanks


John