Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use of MATCH or LOOKUP ? functions | Excel Discussion (Misc queries) | |||
index Match, or Vlookup Match.. | Excel Worksheet Functions | |||
MATCH & IF Functions | Excel Discussion (Misc queries) | |||
Compare and Match Functions | Excel Discussion (Misc queries) | |||
When MATCH and v/hLOOKUP functions *FAIL* to match (but they should)... | Excel Worksheet Functions |