| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
vlookup / len function combined
I have many vlookups referencing cell A1/2/3.....with the text: "firstname".
I now need to add to these cells: "last name". If I add this text, the vlookups search other data tables for "firstname lastname" and return errors. How can I amend the referenced cells (A1/2/3...) so that the vlookups only use "firstname" and disregard the added text ? Tks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Non-sequential VLOOKUP function -OR- sequential sort of web query | Excel Worksheet Functions | |||
| I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions | |||
| carrying a hyper link when using the vlookup function | Excel Worksheet Functions | |||
| carrying a hyper link when using the vlookup function | Excel Worksheet Functions | |||
| Regarding IF function or vLOOKUP function | Excel Worksheet Functions | |||
Threaded Mode
