MATCHING COLUMNS TO ROWS in VB

[davidhall80]

I have data in Column A which matches data in Row 1 starting in column C.



In column B, I want to get the value of the matching cell in column A and row one. Column B is blank, but I would like to get column B to equal the following.
example


........A..........B...........C............D.............E..............F.................G
1............................Zone1......Zone5.......Zone3......Zone8........Zone9

2.Zone8........500......000........56..............72...........500..............78

3.Zone5........56..........76.......56...............43...........865.............954

4.Zone9........94...........72........90...............543.........657............94

5.Zone 3.......56............054......243............56.............905..........809

6.Zone1........000........000.........897..........908............329...........419


B2 should equal the cell that joins the matching column and row. Does this question make sense

 

[pgc01]

Hi davidhall80

With the layout of the example, in B2

=INDEX($A$1:$G$6,MATCH(A2,$A:$A,0),MATCH(A2,$1:$1,0))

Copy down

Hope this helps
PGC

Book1
	A	B	C	D	E	F	G	H	I
1			Zone1	Zone5	Zone3	Zone8	Zone9
2	Zone8	500	0	56	72	500	78
3	Zone5	56	76	56	43	865	954
4	Zone9	94	72	90	543	657	94
5	Zone3	56	54	243	56	905	809
6	Zone1	0	0	897	908	329	419
7
8
Sheet1

 

[davidhall80]

AMAZING!!!!! I was sure this was an impossible question. thanks a million