Matching table A with table B(Plz give a look, m unable to do it)

[livinggourmand]

Hi,
I have 2 table both have more than 10K rows.

I have to find which row in main table corresponds with row in Check table.
note the combination should match not just a column.
ex A25 n B25 (main table) matches with D2 n E2 (check table)
note the combination should match not just a column.

plz let me know if any clarification is required

Thanks

the sheet is uploaded at google doc as i was not able to upload it here
https://docs.google.com/spreadsheet/ccc?key=0AltIfHyzagUAdHBpMkhURlFSbTA0cFJucXpIR1BCQXc&hl=en_US#gid=0

 

[Aladin Akyurek]

What is the Excel version you are working on?

 

[livinggourmand]

excel 2007

 

[Aladin Akyurek]

excel 2007

E3, control+shift+enter, not just enter, and copy down:

=IFERROR(MATCH(D3,IF(A3:$A$29=C3,$B$3:$B$29),0),"no match")

 

[livinggourmand]

E3, control+shift+enter, not just enter, and copy down:

=IFERROR(MATCH(D3,IF(A3:$A$29=C3,$B$3:$B$29),0),"no match")

E column already has values int it

Y on E3

 

[livinggourmand]

i need result in column G as shown in table

 

[livinggourmand]

and whn i try wat u said i get no match in all column

 

[Aladin Akyurek]

and whn i try wat u said i get no match in all column

G3, control+shift+enter, not just enter, and copy down:

=IFERROR(MATCH(E3,IF(A3:$A$29=D3,$B$3:$B$29),0),"no match")

Control+shift+enter means: Press down the control and shift keys together while you hit the enter key at the same time.

 

[livinggourmand]

the result


22
no match
24
24
no match
no match
no match
no match
no match
no match
no match
no match
no match
no match
no match
no match

now?

 

[livinggourmand]

the result is not right