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.
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
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
