alsexceladmin
Board Regular
- Joined
- Jan 17, 2005
- Messages
- 62
I have a spreadsheet set up along with another two ref sheets (Range 1 and 2) and a result sheet. (all on the same page)
Apologies - (I cannot unfortunately download the software at this location to allow me to submit the sheet ) But if it should become necessary, I will do so from home later!
(Range 1) consists of 5 rows and seven columns, each of these rows/cols begin with a text cell, all the other cells contain a number value.
(Range 2 is similar)
I am trying to create a formula to do the following:
I need to identify in turn, the contents of two seperate cells (both text) from the same row in the spreadsheet, then using the two - reference/check lookup (whatevers req) with Range (1) to produce the relevant number value given within this range where the row/cols intersect, then place the result in another cell in the result sheet.
I have got an example set up but for reasons given, cannot yet post the sheet. Sorry!
I am running office 2003 with XP Pro.
Hope you can help.
alsexceladmin
Apologies - (I cannot unfortunately download the software at this location to allow me to submit the sheet ) But if it should become necessary, I will do so from home later!
(Range 1) consists of 5 rows and seven columns, each of these rows/cols begin with a text cell, all the other cells contain a number value.
(Range 2 is similar)
I am trying to create a formula to do the following:
I need to identify in turn, the contents of two seperate cells (both text) from the same row in the spreadsheet, then using the two - reference/check lookup (whatevers req) with Range (1) to produce the relevant number value given within this range where the row/cols intersect, then place the result in another cell in the result sheet.
I have got an example set up but for reasons given, cannot yet post the sheet. Sorry!
I am running office 2003 with XP Pro.
Hope you can help.
alsexceladmin