Output intersection of table

H

HamishM

Hi,

I have TableA of data which needs checking row by row. TableB on a
different sheet contains the values which need to be output. In TableA
need to check Col A and then the value in Col C and return the
intersecting value from TableB into Col D (in TableA).

e.g

TableA:
ColA ColB ColC ColD
Blue Man Car
Red Auto Truck


TableB:
Red Blue Black
Car 9 5 2
Truck 7 4 3

Therefore:
In Row1 in TableA the value in ColD needs to be 5.
In Row2 in TableA the value in ColD needs to be 7.

thanks in advance,
Hamish
 
M

Mark Graesser

Hamish
You need to use a mix of INDEX and MATC

somthing like

=INDEX(table_B, MATCH(C1,header row,0),MATCH(A1,header column,0)

table B reference should not include the row and column lables

Good Luck
Mark Graesse
[email protected]

----- HamishM wrote: ----

Hi

I have TableA of data which needs checking row by row. TableB on
different sheet contains the values which need to be output. In Table
need to check Col A and then the value in Col C and return th
intersecting value from TableB into Col D (in TableA)

e.

TableA
ColA ColB ColC Col
Blue Man Car
Red Auto Truc


TableB
Red Blue Blac
Car 9 5 2
Truck 7 4

Therefore:
In Row1 in TableA the value in ColD needs to be 5
In Row2 in TableA the value in ColD needs to be 7

thanks in advance
Hamis
 
Top