Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
row index number in a hlookup formula
Can someone let me know if it is possible to get the row index number to
change in relation to the row that the formula is copied into when using the fill handle. Here is an example of what I am trying to do. =IF(ISERROR(HLOOKUP($C$1,Data!A:Z,7,FALSE)),"",(HL OOKUP($C$1,Data!A:Z,7,FALSE))) =IF(ISERROR(HLOOKUP($C$1,Data!A:Z,8,FALSE)),"",(HL OOKUP($C$1,Data!A:Z,8,FALSE))) The formulas would be in cells C7 and C8. Thank you for any help here. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
row index number in a hlookup formula
$c1
c1 -- Don Guillett Microsoft MVP Excel SalesAid Software "Crispy" wrote in message ... Can someone let me know if it is possible to get the row index number to change in relation to the row that the formula is copied into when using the fill handle. Here is an example of what I am trying to do. =IF(ISERROR(HLOOKUP($C$1,Data!A:Z,7,FALSE)),"",(HL OOKUP($C$1,Data!A:Z,7,FALSE))) =IF(ISERROR(HLOOKUP($C$1,Data!A:Z,8,FALSE)),"",(HL OOKUP($C$1,Data!A:Z,8,FALSE))) The formulas would be in cells C7 and C8. Thank you for any help here. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HLOOKUP - Relative cell reference in row index number | Excel Discussion (Misc queries) | |||
Help with HLOOKUP/INDEX/MATCH | Excel Worksheet Functions | |||
HLOOKUP copied across rows with "row index number" changing | Excel Worksheet Functions | |||
Index / Hlookup | Excel Worksheet Functions | |||
INDEX,VLOOKUP HLOOKUP ? | Excel Worksheet Functions |