davidhall80
Well-known Member
- Joined
- Jul 8, 2006
- Messages
- 663
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
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