GUIDO22
Registered User.
- Local time
- Today, 21:33
- Joined
- Nov 2, 2003
- Messages
- 515
Hello All!
I have an array of numbers represented in adjacent cells in a spreadsheet as so...
1,2,4,6,7,9,15,23,28,32 for example.
I also have a pair of numbers. One number the array reference, the other the offset.
I wish to be able to return the value in the array at (reference + offset).
So, if I had the following :
Reference : 6 & Offset : 4 the (returned) cell value would be 23 from the example above...
ie. find value 6 in the array, then move '4' places to the right ..
Any ideas how I can represent this functionality as a formula in a spreadsheet please...?
Thanks
I have an array of numbers represented in adjacent cells in a spreadsheet as so...
1,2,4,6,7,9,15,23,28,32 for example.
I also have a pair of numbers. One number the array reference, the other the offset.
I wish to be able to return the value in the array at (reference + offset).
So, if I had the following :
Reference : 6 & Offset : 4 the (returned) cell value would be 23 from the example above...
ie. find value 6 in the array, then move '4' places to the right ..
Any ideas how I can represent this functionality as a formula in a spreadsheet please...?
Thanks