Lookup with two values

I

itty

Can anybody help me to do lookup function with two values.
For eg.,
Sheet one having:
Part no OrderNo Status (in column A,B,C consecutively)

Sheet two having
Part No OrderNo in column A, B Consecutively).

I want to add Status from Sheet one to Sheet2 in columnC, looking into
both partno and orderNo as lookup value. DGET is not working.
Thanks in advance,
itty.
 
R

Roger Govier

Hi

One way would be to use an extra column with a concatenation of columns A
and B.
Insert a new column C on both sheets
In C2 enter = A2&"|"&B2
Copy down for the range of cells required. Repeat for second sheet, or group
sheets together before carrying out this task.
On sheet 2 in cell D2 enter
=IF(ISNA(VLOOKUP(C2,Sheet1!$C$2:$D$200,2,0)),"",VLOOKUP(C2,Sheet1!$C$2:$D$20
0,2,0))
Copy down column D on Sheet 2
You could then hide column C on both sheets if required.

Change the range C2:D2000 to suit the range of data you are dealing with.
 
I

itty

Dear Roger Govier and Smile,
I was not visiting the forum for two days. I checked the reply from Mr.
Govier, It worked perfectly. Thanks and sorry for the delay.
Itty
 
Top