| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup with indirect
Did that and it doesnt work.
Thanks John |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup with indirect
Tonto wrote: Did that and it doesnt work. Thanks John SORTED Setup was bringing an extra space between names. Thanks John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP from closed file using INDIRECT function | Excel Worksheet Functions | |||
| Indirect Vlookup with RC[-1] | Excel Worksheet Functions | |||
| how to use 2 worksheets in one formula with INDIRECT & VLOOKUP | Excel Worksheet Functions | |||
| Confusing VLOOKUP with Indirect reference | Excel Worksheet Functions | |||
| vlookup, &, indirect | Excel Worksheet Functions | |||
Linear Mode
