Formula for Searching & matching two values in excel
 

Hello I wonder if anyone can help with my problem....

I need to create a lookup to match two values in one
worksheet with two values in another sheet, returning a
third value:

So I have two worksheets in excel Projects and Orders.
To match these sheets, the Orders page contains lots of
duplicate "Order Codes" which are numbered between 1 & 20
called "Line item". These Order line items each refer to a
particular Project on the Projects sheet but can only be
traced to a Project by searching the Projects sheet for
Order number then Line item. So for instance Order 1234
Line Item 1 refers to Project 1; Order 1234 Line Item 2
may refer to a different Project i.e. 2.

So I need to be able to create a formular on the Orders
page to search the Projects sheet for "Order Code" to find
all the orders, then find the matching "Line Item Number"
(1-10) returning the particular PROJECT number.

I have been trying to use vLookup and Index, but failing.

Can anyone help?

Thanks
Chris

Sounds Like you need to use SUMIF, instead of a lookup!



-----Original Message-----
Hello I wonder if anyone can help with my problem....

I need to create a lookup to match two values in one
worksheet with two values in another sheet, returning a
third value:

So I have two worksheets in excel Projects and Orders.
To match these sheets, the Orders page contains lots of
duplicate "Order Codes" which are numbered between 1 &
20
called "Line item". These Order line items each refer to
a
particular Project on the Projects sheet but can only be
traced to a Project by searching the Projects sheet for
Order number then Line item. So for instance Order 1234
Line Item 1 refers to Project 1; Order 1234 Line Item 2
may refer to a different Project i.e. 2.

So I need to be able to create a formular on the Orders
page to search the Projects sheet for "Order Code" to
find
all the orders, then find the matching "Line Item
Number"
(1-10) returning the particular PROJECT number.

I have been trying to use vLookup and Index, but
failing.

Can anyone help?

Thanks
Chris

.