| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Adding to VLOOKUP table
I have a table to which I have added 2 further columns
I have a formula which looks up colums 2 and 3 when I key data in column 1 =if(trim(a23)="","",vlookup(a23,scanner_table,2,0) ) The new data I want to select is in column 5 so =if(trim(a24)="","",vlookup(a24,scanner_table,5,0) ) to which I get the raspberry #REF I am sure this must be very basic but sometimes I can't see the wood for trees Any comments would be much appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
| vlookup with validation table | Excel Discussion (Misc queries) | |||
| Table Array in VLOOKUP Relies on Data Validation | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
| Adding a formula to a pivot table | Excel Discussion (Misc queries) | |||
Threaded Mode
