HLookup fails when inserting row?

  • Thread starter Thread starter girthhart
  • Start date Start date
G

girthhart

I am using HLookup to draw data from a range in another workbook, bu
when I insert rows, the row index number doesn't change therefore th
formula references to the newly inserted row and not the data in th
row below. Is there a way of fixing the row index number so that whe
you insert / delete rows within the source range the formula reference
to the original row
 
insert before the last row or define a name for a self adjusting table.
 
You must log in or register to reply 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

Inserting a Copied Row inside a table 6
HLOOKUP - Relative cell reference in row index number 0
automatically numbering rows 2
HLOOKUP-ish? 2
Display data using hlookup, index-match and offset 1
need to have SUM formula update on row add/delete/move - Excel 2003 14
Macro to take to last line and insert new row with number 3
Macro to fill down automatically the number of rows in a spreadsheet 1

Back
Top