Using a Variable for Reference in Offset

[ExcelJeff]

How can I use a variable for the reference of an Offset lookup?

I want users to select the metric they want data from by using a dropdown. The results of the dropdown should then drive the reference field in the offset function.

Something like this:
=OFFSET(MyVariable, 1,1)

Thanks in advance for any help.

 

[ExcelJeff]

Try

=OFFSET(INDIRECT(A1),1,0,1,1)

A1 = your cell that contains either NatrualSearch or PaidSearch derived from your dropdown.

BINGO!

Thank you so much!!!

 

[Jonmo1]

Glad to help out.