row index number in a hlookup formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Crispy - 16 Sep 2007 18:30 GMT

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)),"",(HLOOKUP($C$1,Data!A:Z,7,FALSE)))
=IF(ISERROR(HLOOKUP($C$1,Data!A:Z,8,FALSE)),"",(HLOOKUP($C$1,Data!A:Z,8,FALSE)))
The formulas would be in cells C7 and C8.
Thank you for any help here.

Reply to this Message

Don Guillett - 16 Sep 2007 19:38 GMT

$c1
c1

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> 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
[quoted text clipped - 4 lines]
> The formulas would be in cells C7 and C8.
> Thank you for any help here.

Reply to this Message