=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
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