row index number (hlookup)

M

Mark Thomas

=IF(F4="","",(HLOOKUP(F4,$R$2:IV251,3,FALSE))) is my formula

I need The three (row index number argument) to roll progressively or match the row of the formula. So when I copy the formula down it will change to 4, 5 so on, or match the row number. Any help is greatly appreciated. Thank you. Mark
 
F

Frank Kabel

Hi
try
=IF(F4="","",(HLOOKUP(F4,$R$2:IV251,ROW()-1,FALSE)))
assuming that this formula is in row 4. copy down
 
A

Arvi Laanemets

Hi

=IF(F4="","",(HLOOKUP(F4,$R$2:IV251,ROW(F3),FALSE)))


--
(Don't use my reply address - it's spam-trap)

Arvi Laanemets



Mark Thomas said:
=IF(F4="","",(HLOOKUP(F4,$R$2:IV251,3,FALSE))) is my formula.

I need The three (row index number argument) to roll progressively or
Click to expand...
match the row of the formula. So when I copy the formula down it will
change to 4, 5 so on, or match the row number. Any help is greatly
appreciated. Thank you. Mark
 

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

MATCH to return row number not working in HLOOKUP 2
HLOOKUP & VLOOKUP Combinded 4
Mapping strings to integers 6
return multiple values when within range (greater than and less than) 11
using hlookup to reference a column in a vlookup formula? 3
if/true/false help 3
Match and delete rows on two different sheets from reference numbers 4
Hlookup, range_lookup parameter 1

Top