Dale

You us Match as the Offset part of the lookup function as it returns the
index number of the range, so in Pseudo code.

=HLOOKUP(A1,SHEET1!$A$1:$Z$1000,MATCH(12,$A$1:$M$1 ,0),FALSE)

This uses the MATCH function to provide the offset to the HLOOKUP. So if the
range A1:M1 has 0,1,2,3,4,5,6,7,8,9,10,11,12,13 in it then the offset would
be 13 as 12 is the 13th item in the array.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk





"Dale" wrote in message
...
I need to "cross hair" a cell and I cannot remember how to use these
functions to accomplish that result. Can someone help.

Thanks

Dale