| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP and names with Commas
I am using the below formula in D195 to look up an employee's hours.
B195 is Doe, Jane from the search array, Doe, Jane is in B139 and Doe, Jack is in B138. The values keep pulling from Jack. Is there a way force it to pull from Jane? =VLOOKUP(B195,$B$9:$G$190,2) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation With VLOOKUP & Names | Excel Worksheet Functions | |||
| VLookup on same last names - different people | Excel Discussion (Misc queries) | |||
| VLOOKUP and LEN/ISNA to match names? | Excel Worksheet Functions | |||
| VLOOKUP results on last names | Excel Worksheet Functions | |||
| Using Vlookup to look at different names sets of data.... | Excel Worksheet Functions | |||
Threaded Mode
