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 -

lookup function to meet two conditions
 

Sorry the formatting messed up :
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 - - -
325 1
325 2
326 1
326 2
327 1
327 2

- then seperate data with the following:
SO#'s Line Number Product descript
314 8 widget fluffy
325 2 wood
326 1 sofa



So i want to match both the SO# and the Line # and then if it matches return
the product description.

Thank you kindly -



"Sean" wrote:

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 -

lookup function to meet two conditions
 

Assume this table below is in cols A to C:

SO#'s Line Number Product descript
314 8 widget fluffy
326 2 wood
326 1 sofa
....

You could use an array-entered* index/match,
something like this:
=index(C2:C10,match(1,(a2:a10=326)*(b2:b10=2),0))
to return the product descript from col C (ie wood),
given an SO# (eg: 326) & line number (eg: 2)

*ie formula is confirmed via pressing CTRL+SHIFT+ENTER
instead of just pressing ENTER
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,700 Files:359 Subscribers:55
xdemechanik
---