I have a formula in Cell M3 as "IFERROR(VLOOKUP(A3,FORM5!A3:C13,3,0),VLOOKUP(A3,Entry!B9:J10,9,0))" .
When I copy the formula to Cell M4 the formula changes to "IFERROR(VLOOKUP(A4,FORM5!A4:C14,3,0),VLOOKUP(A4,Entry!B10:J11,9,0))".
I would like to have the table of array in formula A3:C13 and B9:J10 to remain constant while copying and only the look up A3 should change to A4.
This is required when i copy the formula horizontally to next column or vertically to next row
Bookmarks