Lookup with offset

[Chewyhairball]

Hi Folks

I have the following hlookup which works fine

=HLOOKUP($C$9,Sheet1!$F$2:$BE$43,4,0)

However i would like something that could lookup C9 in F2:BE43 but instead of going to row4 i would like it to go to down 9 rows and accross 3.

The data is not in a normal table format (exported from database) with some columns of data not aligning with the main header.
I could do a macro to straighten up all the data but i dont want to do that.

Im sure it will be some sort of index match formula but i cant figure it out.

thanks

Rory

 

[Fluff]

How about

=INDEX(Sheet1!F9:BE9,MATCH(C9,Sheet1!F2:BE2,0)+3)

 

[Chewyhairball]

Thank you, thankyou, thank you.

I love my excel and formulas and macros but i still think i only know less than 1% of it all.

cheers Fluff

 

[Fluff]

You're welcome & thanks for the feedback.