Copy formulas horizontal and vertical

[flakedew]

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.

Please help.

 

[VoG]

Try

=IFERROR(VLOOKUP(A3,FORM5!$A$3:$C$13,3,0),VLOOKUP(A3,Entry!$B$9:$J$10,9,0))

 

[flakedew]

Thanx a lot, works perfect

 

[flakedew]

Thanx a lot, works perfect