Using OFFSET function to return the value from another cell with row and column offset

Hello,

I am having some difficulties using a combination of IF and the OFFSET function to display a range of cell values from another column based on a simple condition. The values I need to display at the destination cells should be offset by 8 columns to the right and "X" rows down from the reference column. The value "X" is to be determined via the IF function to check for the row index number.

For example, if Index value "X" = 8, then display the value of B2 in cell I9. IF X = "9", display B2 in cell I10 etc.

I have attached a sample worksheet that provides some examples.

Thank you for your help.

Regards
engine44

So, I'm not exactly sure where you want each column looking for the index, but I made a show at what you're asking for. You can do it with index, offset, or indirect. I chose to show you offset and index. If you're every using an external reference, only index works.

Hello K64,

This is exactly what I was trying to achieve. Thank you for both options. I also made a slight refinement to the OFFSET solution to get rid of the header since it is a non-data line.



Regards

Good idea. Glad I could help.