Lookup with two values

  • Thread starter Thread starter itty
  • Start date Start date
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.
 
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.
 
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
 
Back
Top