Autofill help!!

[igorski88]

I am auto filling the following into aboit 100 rows:

=IFERROR(VLOOKUP(A10,'SW&M FFEX'!A9:E20,5,FALSE),"N/A")

all I want it to do is auto fill the A10 part to A11 and so on.

The issue: A9:E20 part is auto filling to A10:E21. but I dont want it to. any help is much apriecated

 

[VoG]

Try

=IFERROR(VLOOKUP(A10,'SW&M FFEX'!A$9:E$20,5,FALSE),"N/A")

 

[Scott Huish]

If VLOOKUP doesn't find the value it is going to generate an #N/A error anyway. Why the IFERROR?

 

[igorski88]

your F'n awsome!!!!!! it works

 

[VoG]

You are welcome. For why see http://www.cpearson.com/excel/relative.aspx

Also, HP has a good point.

 

[igorski88]

I just dint want the "#"