Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlook Up | Excel Worksheet Functions | |||
VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
Need Help about vlook | Excel Worksheet Functions | |||
Vlook | Excel Worksheet Functions |