vlookup and match functions

  • Thread starter Thread starter Dale
  • Start date Start date
D

Dale

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
 
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
 
Back
Top