OFFSET with HLOOKUP

[excel?]

Is there a way to use OFFSET (or something else) with a HLOOKUP formula?

I use the HLOOKUP formula to extract specific data into a seperate spreadsheet, but I have had to do a calculation in the cell next to the original data and now need to pull that amount into the seperate sheet. (I cannot put the new calculation above or below only beside).

I had thought that the OFFSET reference could be the HLOOKUP formula then I tell it to move over 1 column and return that amount.

Any solutions?

Thanks

 

[Domenic]

Use INDEX/MATCH to give you your starting reference for OFFSET....

=OFFSET(INDEX(…..MATCH(…..)),rows,cols,height,width)

Hope this helps!