Register
Log In
Unanswered
Home
New Member
June 27, 2016
Offline
Is there a way to have a HLOOKUP formula update automatically if a row is inserted or deleted. At this time I have to update all the formulas manually. This is quite time consuming and limits how much I manipulate the data.
July 16, 2010
Offline
I'm not sure which part of the formula you want updated, the table_array or the row_index_num?
If it's the row_index_num then you can use the ROW or ROWS function. This tutorial explains how to use the COLUMNS function in VLOOKUP. For HLOOKUP simply replace COLUMNS with ROWS
More on using COLUMNS and ROWS functions for dynamic referencing: https://www.myonlinetraininghub.com/excel-rows-and-columns-functions
If you get stuck please provide an example workbook so we can give you more tailored instructions.
Mynda
February 5, 2016
Offline
the HLOOKUP Can automatically be updalted by using match formula on the row_index_number part on the hlookup formula.Kindly attach the file and can assist .The MATCH can also be used for this on the VLOOKUP ,INDEX and OFFSET formula as well
Most Users Ever Online: 57
Currently Online: Ali Bokhari
1 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Ali raza
Susan Booze
Rita Hrez
David Innes
preeti bhulabhai
Charles Klasek
Patrick Isedu
Emma Hayward
Vamseedhar G
NA NA
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
