| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
LOOKUP value based on 2 criteria
I hope someone can help me. I have 2 databases, one that records order info,
and the other that records shipping info. After pivoting the data in the shipping database, I want to transfer the total quantity shipped against a particular order to the order database. However, one order # can have several part #'s associated with it. Is there a way to lookup Order # (Column A) AND Part # (Column B) to retrieve the correct data for the specific part? Please help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup with 2 criteria | Excel Discussion (Misc queries) | |||
| lookup with 2 criteria | Excel Discussion (Misc queries) | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
| Lookup with search range start based on position of last blank lin | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Threaded Mode
