| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLookup problem when a new row has been inserted
Are you really sure the data is sorted? If not, then try
VLOOKUP($C$7,EmployeeData,2,FALSE). Are you really sure that nobody inserted a column? If not then retrieve the search and the lookup range (S1:S999 and L1:L999, maybe, if in same sheet) and try INDEX (L1:L999,MATCH($C$7,S1:S999,FALSE)). HTH, Bernd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can IF and VLOOKUP functions be inserted together? | Excel Discussion (Misc queries) | |||
| VLOOKUP Problem | Excel Worksheet Functions | |||
| Inserted Columns into VLOOKUP Tables | Excel Discussion (Misc queries) | |||
| VLOOKUP problem (N/V) | Excel Worksheet Functions | |||
| Vlookup Problem | Excel Worksheet Functions | |||
Threaded Mode
