Hi, I have a worksheet with the following data in column A5 down:
SR1
SR2
SR3
SR4
CS1
CS2
CS3
CS4
GP1
GP2
GP3
GP4
and row 3 with data 11, 12, 13, ..., 79
Then on another sheet on cells B4 and B5, you insert row code and column code respectively... so in cell B4 I would enter CS4 (example), and in cell B5 I would enter 17 (example)... I need a formula to look at cells B4 and B5 and find the data in the large table described above... any help would be useful
SR1
SR2
SR3
SR4
CS1
CS2
CS3
CS4
GP1
GP2
GP3
GP4
and row 3 with data 11, 12, 13, ..., 79
Then on another sheet on cells B4 and B5, you insert row code and column code respectively... so in cell B4 I would enter CS4 (example), and in cell B5 I would enter 17 (example)... I need a formula to look at cells B4 and B5 and find the data in the large table described above... any help would be useful