| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can VLOOKUP identify between multiple choices for > 1 batch?
We are a manufacturing unit and produce mulitple items from one job. So Job
"A" may result in products "B" & "C". VLOOKUP will only find the first instance when running stock reports as it only searches on 1 column. Is there a way to have this function look at multiple (2 columns) and return a value? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I use vlookup for multiple occurrences of the same value | Excel Worksheet Functions | |||
| Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
| vlookup with multiple lines of same value | Excel Worksheet Functions | |||
| vlookup over multiple worksheets | Excel Worksheet Functions | |||
| Multiple Vlookup? | Excel Worksheet Functions | |||
Threaded Mode
