| 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 |
| 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 | |||
Threaded Mode
