Hello,
I have this formula:
Formula:![]()
=IFERROR(XLOOKUP($J$5,'Exercise Table'!$D$7:$D$25,'Exercise Table'!$I$7:$I$25),"No Instructions Found")
If I add to table rows it leaves out data for new rows.
D header: Exercise Name
I header: Cleaned and Trimmed Instruction
Can the table headers be referenced so that the new table row data isn't neglected?
I can provide workbook if needed.
Thank you
Bookmarks