row index number in a hlookup formula

C

Crispy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

InputBox for column letter problem 2
HLOOKUP, LOOKUP & MATCH doesn't work. Seems not right. 1
What does allcalc (a table_array) refer to in a cell formula? 1
HLOOKUP - Relative cell reference in row index number 0
HLOOKUP Can't Search by Lookup Value 0
HLOOKUP problems 1
COMPLICATED FORMULA WITH EMBEDDED HLOOKUP 2
How to get Col and Row returned in an hLookup? 2

Top