If error look up formula, not copying & pasting correctly

[mckeamic]

=IFERROR(VLOOKUP(C5,’species and specs’!B5:D126,3,FALSE),””) is the formula that I am using

Here is my formula that works, but I have to paste the formula in a column from C5 to C604. Unfortunately though when I copy then paste it in the next cell, it changes the formula each time I paste it.

It changes in the part B5:D126, it adds one every time I paste (ie B6:D127, then B7:D128, etc...)

Any suggestions??

Thanks in advance

 

[jtakw]

Hi,

You need to add absolute referencing for the Rows in your Lookup Table if you're copying the formula Up or Down, like this:

=IFERROR(VLOOKUP(C5,'species and specs'!B$5:D$126,3,FALSE),"")

 

[Gerald Higgins]

Try

=IFERROR(VLOOKUP(C5,’species and specs’!B$5:D$126,3,FALSE),””)

Edit - ooh, too slow

 

[mckeamic]

I love this group, you guys are so awesome...

I will try right now and let you know if it works

Thanks

 

[mckeamic]

You guys are amazing....It totally worked and ya'll saved me so much time.

Thanks again

 

[jtakw]

You're welcome, glad we can help.