Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup function to meet two conditions
I want to use a lookup function to meet two criteria. I have Sales Order
numbers in one column and line items in another. So i want to say 'match the sales order# and the line item number and return back the item description' SO#'s Line Number - - - - -- - then seperate data with the following: 325 1 SO#'s Line Number Product descript 325 2 314 8 widget fluffy 326 1 325 2 wood 326 2 326 1 sofa 327 1 327 2 So i want to match both the SO# and the Line # and then if it matches return the product description. Thank you kindly - |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If formula with two conditions to meet | Excel Worksheet Functions | |||
Counting rows that meet conditions in multiple columns | Excel Worksheet Functions | |||
Array to meet conditions | Excel Worksheet Functions | |||
Lookup function with mulitple conditions | Excel Worksheet Functions | |||
Hiding rows that meet multiple conditions in excel | Excel Discussion (Misc queries) |