Array Index / Offset Query

jeudi 23 avril 2015

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
Array Index / Offset Query

0 commentaires:

Enregistrer un commentaire

Labels