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
(e-mail address removed)
web:
www.excelusergroup.org
web:
www.nickhodge.co.uk