Searching values from two different tables

[mazen889]

Hello,

I need help with searching for values from two different tables using excel.
My first table looks like:
Diameter Thickness Drift Value
1.0 0.3
1.0 0.5
1.0 0.6
1.5 0.5
1.5 0.7
etc

My second table looks like this:
Diameter Thickness Drift Value
1.0 0.3 1.5
1.0 0.4 2.5
1.0 0.5 3.5
1.0 0.6 4.5
1.5 0.3 8.2
1.5 0.5 9.6
etc

I have more than 15,000 rows in the first table; and around 500 rows in the second.

I need to find the matching values of diameter and thickness in each table; their matching drift value, and then copy that to the third column of the first table.

Please help me out as I am completly lost.

Thank you very much.

[windknife]

Try this,

C2

Please Login or Register  to view this content.

copied down,

You can also see attached file.
HTH,
windknife

[StephenR]

If your second table is in G2:I7, enter this formula in J2 and copy down:

=G2&"#"&H2

If your first table is in A2:B6, enter this formula in C2 and copy down:

=INDEX($I$2:$I$7,MATCH(A2&"#"&B2,$J$2:$J$7,0))

Adjust bold ranges accordingly.

[mazen889]

Worked like a charm, both methods.
Thank you very very much!!!!!!!!!