VlookUp or may be Match Function

[Hardeep_kanwar]

Hey Experts

My Data looks Like this

Name City Total
ABC Delhi 24.06
ABC Delhi
ABC Delhi
ABC Delhi
ABC Noida 12
DEF Noida 47
DEF Noida
GHI Faridabad 24.3
JKL Mumbai 151
JKL Mumbai
JKL Mumbai
JKL Mumbai
JKL Mumbai
JKL Naskik 29
JKL Naskik
MNO Chennai 25
MNO Chennai
MNO Hyderabad 15
PQR Noida 12
PQR Delhi 26
PQR Delhi
STU Hyderabad 35
STU Hyderabad
VWX Gurgaon 35
VWX Gurgaon
VWX Delhi 21
XYZ Gurgaon 45
XYZ Gurgaon
XYZ Noida 26
XYZ Delhi 87
XYZ Delhi
XYZ Delhi

And i another data like this:

Name City Total
ABC Delhi 24.06
ABC Noida 12
DEF Noida 47
GHI Faridabad 24.3
JKL Mumbai 151
JKL Naskik 29
MNO Chennai 25
MNO Hyderabad 15
PQR Delhi 26
PQR Noida 12
STU Hyderabad 35
VWX Delhi 21
VWX Gurgaon 35
XYZ Delhi 87
XYZ Gurgaon 45
XYZ Noida 26
Now want to get the Value in First Example Searching from Second Example.
As Shown in Column C.

Thanks in Advance.


Hardeep kanwar

 

[Sheeloo]

One way...

Insert a Col before Col A (assuming sheetname is Sheet2) in the second set
and use this formula in the new A2
=B2&C2
and copy down.

Now in the first sheet C2 C enter this
=VLOOKUP(A2&B2,Sheet2!A,4,False) and copy down...

If you don't want #N/A values then use this
=IF(ISNA(VLOOKUP(A2&B2,Sheet2!A,4,False)),"",VLOOKUP(A2&B2,Sheet2!A,4,False))

 

[Hardeep_kanwar]

WoW

Great Sheeloo

Thanks


Hardeep kanwar

One way...

Insert a Col before Col A (assuming sheetname is Sheet2) in the second set
and use this formula in the new A2
=B2&C2
and copy down.

Now in the first sheet C2 C enter this
=VLOOKUP(A2&B2,Sheet2!A,4,False) and copy down...

If you don't want #N/A values then use this
=IF(ISNA(VLOOKUP(A2&B2,Sheet2!A,4,False)),"",VLOOKUP(A2&B2,Sheet2!A,4,False))