vlookup and match functions
 

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

vlookup and match functions
 

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