Hello Experts,
Please see the below Index match formula that i have written. I need to know how can i edit this formula so that it can automatically pick up any new columns or rows that i insert after Column FJ and Row 139. Currently when i add new columns or rows i have to manually adjust the formulas and this takes a lot of time.
Index(D9 : FJ139), Match(A159, A9:A139,0), Match(D150,D6:FJ6)
Thanks
Headley.
Bookmarks