Output intersection of table

  • Thread starter Thread starter HamishM
  • Start date Start date
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
 
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
(e-mail address removed)

----- 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
 
Back
Top