how if and vlook up is used
 

Table 1 Table 2
Column A Column B Column D Column E
56650 LSE 56650 LSE
56650 LSE 154004
154004 263494 LSE
263494 LSE 329459 LSE
263494 LSE 397445
263494 LSE 408284 LSE
329459 LSE 434256 LSE
26842UFE5 ASE
912820JE8 ASE LUX
ANN5632H8391 LUX LUX
ANN5633L1100 LUX B00SMQ3
ARARGE035162 B00G0S5 HKG
B00G0S5 HKG B00G0S5 HKG

I want to Compare Column A Data + column B data together mathces with column
D + Colum E Data . Tell me what formula i should use? Vlookup or combination
of If and Vlookup

how if and vlook up is used
 

Amit wrote:
Table 1 Table 2
Column A Column B Column D Column E
56650 LSE 56650 LSE
56650 LSE 154004
154004 263494 LSE
263494 LSE 329459 LSE
263494 LSE 397445
263494 LSE 408284 LSE
329459 LSE 434256 LSE
26842UFE5 ASE
912820JE8 ASE LUX
ANN5632H8391 LUX LUX
ANN5633L1100 LUX B00SMQ3
ARARGE035162 B00G0S5 HKG
B00G0S5 HKG B00G0S5 HKG

I want to Compare Column A Data + column B data together mathces with column
D + Colum E Data . Tell me what formula i should use? Vlookup or combination
of If and Vlookup

Hi Amit,

One way you can do this uses a couple helper columns.

In column G place
=A3&B3

In column H place
=D3&E3

Finally, the result in column H:
=IF(ISNA(VLOOKUP(G3,$H$3:$H$15,1,FALSE)),"miss","h it")


Another way does not use helper columns, but only this array formula
(commit with Ctrl+Shift+Enter):

=IF(ISNA(VLOOKUP(A3&B3,$D$3:$D$15&$E$3:$E$15,1,FAL SE)),"miss","hit")