NBVC
Well-known Member
- Joined
- Aug 31, 2005
- Messages
- 5,828
I feel embarrassed but I can't seem to figure this one out.
This is my Sheet 2:
I want to get the result from Sheet 1, knowing the coordinates are as shown in the table.
I can't figure out how to best combine the fact that the data is in sheet1 and the address(c2,b2) function.
This is my Sheet 2:
Book1.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Column No. | Row No. | Result | |||
2 | Product C | 3 | 5 | |||
3 | Product D | 5 | 8 | |||
Sheet2 |
I want to get the result from Sheet 1, knowing the coordinates are as shown in the table.
I can't figure out how to best combine the fact that the data is in sheet1 and the address(c2,b2) function.