Offset values based on a defined value

[Elitdarkphoenix]

Hello gentleman

Im having a small issue with finding the correct way to make a formula. i request your assistance.

i would like to find a value in a table based on something like this:

=INDEX(X:X,MATCH(S,$B$:$B$,0),MATCH(R$,$C$:$N$,0))

the problem is that i need it to go up or down the table (3 cells up or 3 cells down ) depending on a cell that provides me the values that mimic the behaviour.
so if cell A1 is -3 i want the cell reference to go up 3 cells if its 3 i want it to go down 3 cells, and return the value that is found there.

Any ideas how to achieve this?

 

[CyrusTheVirus]

the problem is that i need it to go up or down the table

What do you mean by 'it'?

I'd suggest creating a sample spreadsheet of your table to show us what your data looks like and also show your expected result(s).

 

[tr3der]

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; color: #454545}</style>I have a spreadsheet with months 1,2,3 etc across the rows and a specific number of months to count backwards in a cell. I want to use the offset function to count back 6 columns from the reference cell. However, the 6 month count results in being either off the spreadsheet or into my column with all my field labels. This is causing the error either #value or #ref.. Unless I put the offset formula starting after column F (6 columns forward). How can I incorporate the offset function while not going off the sheet or into a cell that has text?