vlookup with indirect

[Tonto]

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

 

[Tonto]

Tonto wrote:

It should be data not DATE Sorry

 

[PCLIVE]

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

 

[Tonto]

Did that and it doesnt work.

Thanks

John

 

[Tonto]

Did that and it doesnt work.

Thanks

John

SORTED

Setup was bringing an extra space between names.

Thanks


John