Help with OFFSET Function

[taylorbe]

Good Afternoon All,

I am having trouble trying to get my OFFSET function to work, which can be found below.

=OFFSET(MasterList! & ADDRESS(MATCH(C2, MasterList!C:C, 0), COLUMN(MasterList!C2),4), 0, 5)

What I need this function to do in simpler terms is, =OFFSET(MasterList! & Whatever cell ADDRESS returns, #Rows, #Columns)

MATCH is looking up a value from a data validation list in C2 of the current sheet under the column heading in a separate sheet.

I would simply use VLOOKUP to resolve issues, but this function is being used for a Data Validation Source, and the Source seems to hate VLOOKUP for some reason or another. Any help with this issue would be greatly appreciated.

Thanks!

[Jonmo1]

Try
=INDEX(MasterList!H:H,MATCH(C2, MasterList!C:C, 0))

[taylorbe]

Jonmo,

That formula seemed to work perfectly for me. Don't know why I decided to overcomplicate things; thanks for the assistance!

[Jonmo1]

You're welcome.