Chewyhairball
Active Member
- Joined
- Nov 30, 2017
- Messages
- 312
- Office Version
- 365
- Platform
- Windows
Hi Folks
I have the following hlookup which works fine
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
I have the following hlookup which works fine
Excel Formula:
=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