| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vLookup from 2 different lists
I have a pallet of product to be disposed of and I need to check whether its
serial number appears on a "Approved" list or a "Not Approved" list (2 different sheets both lists named). I have currently have 2 colomns (1 for each list) but would like to have only 1 colomn to show whether a product is "Approved" "Not Approved" or " Not Dealt with". Thanks for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup and drop down lists | Excel Discussion (Misc queries) | |||
| VLOOKUP and Multi Lists | New Users to Excel | |||
| VLOOKUP and Multi Lists | Excel Worksheet Functions | |||
| Help Please with Dropdown lists and Vlookup | Excel Discussion (Misc queries) | |||
| Vlookup from lists | Excel Discussion (Misc queries) | |||
Threaded Mode
