VLOOKUP...have 3pm deadline but making progress almost there!
 

Hello and thank you to EVERYONE for your help.

I am using the VLOOKUP function but am having some trouble with it. I have
enetered in the formula and it works for a single cell, but when I copy it
down it changes the formula in a few ways and I come up with REF#'s.

Here is my formula for the first few cells which I have got to work by
editing the cell each time, but I cannot copy it down.

=VLOOKUP(B2,'Master List'!A2:B75,'Master List'!B1) WORKS!
=VLOOKUP(B3,'Master List'!A2:B75,'Master List'!B1) WORKS!
=VLOOKUP(B4,'Master List'!A2:B75,'Master List'!B1) WORKS!
=VLOOKUP(B5,'Master List'!A2:B75,'Master List'!B1) WORKS!

=VLOOKUP(B6,'Master List'!A6:B79,'Master List'!B5) DOSEN'T WORK :-(

Why is it that A2 changed to A6 and B75 to B79???

heres the next if it helps

=VLOOKUP(B7,'Master List'!A6:B79,'Master List'!B5)
=VLOOKUP(B8,'Master List'!A6:B79,'Master List'!B5)

Notice on the next it changes again! Now its A10 and B83???
=VLOOKUP(B10,'Master List'!A10:B83,'Master List'!B9)

VLOOKUP...have 3pm deadline but making progress almost there!
 

Put $ signs around the range.

=VLOOKUP(B2,'Master List'!$A$2:$B$75,'Master List'!B1)

Now drag copy down the column.

"conditional format if cell contains word" wrote:

Hello and thank you to EVERYONE for your help.

I am using the VLOOKUP function but am having some trouble with it. I have
enetered in the formula and it works for a single cell, but when I copy it
down it changes the formula in a few ways and I come up with REF#'s.

Here is my formula for the first few cells which I have got to work by
editing the cell each time, but I cannot copy it down.

=VLOOKUP(B2,'Master List'!A2:B75,'Master List'!B1) WORKS!
=VLOOKUP(B3,'Master List'!A2:B75,'Master List'!B1) WORKS!
=VLOOKUP(B4,'Master List'!A2:B75,'Master List'!B1) WORKS!
=VLOOKUP(B5,'Master List'!A2:B75,'Master List'!B1) WORKS!

=VLOOKUP(B6,'Master List'!A6:B79,'Master List'!B5) DOSEN'T WORK :-(

Why is it that A2 changed to A6 and B75 to B79???

heres the next if it helps

=VLOOKUP(B7,'Master List'!A6:B79,'Master List'!B5)
=VLOOKUP(B8,'Master List'!A6:B79,'Master List'!B5)

Notice on the next it changes again! Now its A10 and B83???
=VLOOKUP(B10,'Master List'!A10:B83,'Master List'!B9)

VLOOKUP...have 3pm deadline but making progress almost there!
 

Hi

you have to enter $ in front of your numbers if you want to keep it
referenced to that #

=VLOOKUP(B5,'Master List'!A$2:B$75,'Master List'!B$1)

change the other formulas as the one above and copy them

if this help please click yes, thanks

"conditional format if cell contains word" wrote:

Hello and thank you to EVERYONE for your help.

I am using the VLOOKUP function but am having some trouble with it. I have
enetered in the formula and it works for a single cell, but when I copy it
down it changes the formula in a few ways and I come up with REF#'s.

Here is my formula for the first few cells which I have got to work by
editing the cell each time, but I cannot copy it down.

=VLOOKUP(B2,'Master List'!A2:B75,'Master List'!B1) WORKS!
=VLOOKUP(B3,'Master List'!A2:B75,'Master List'!B1) WORKS!
=VLOOKUP(B4,'Master List'!A2:B75,'Master List'!B1) WORKS!
=VLOOKUP(B5,'Master List'!A2:B75,'Master List'!B1) WORKS!

=VLOOKUP(B6,'Master List'!A6:B79,'Master List'!B5) DOSEN'T WORK :-(

Why is it that A2 changed to A6 and B75 to B79???

heres the next if it helps

=VLOOKUP(B7,'Master List'!A6:B79,'Master List'!B5)
=VLOOKUP(B8,'Master List'!A6:B79,'Master List'!B5)

Notice on the next it changes again! Now its A10 and B83???
=VLOOKUP(B10,'Master List'!A10:B83,'Master List'!B9)

VLOOKUP...have 3pm deadline but making progress almost there!
 

THANK YOU! It's completed and I am going to send off to CFIA now.Thank you

"Eduardo" wrote:

Hi

you have to enter $ in front of your numbers if you want to keep it
referenced to that #

=VLOOKUP(B5,'Master List'!A$2:B$75,'Master List'!B$1)

change the other formulas as the one above and copy them

if this help please click yes, thanks

"conditional format if cell contains word" wrote:

Hello and thank you to EVERYONE for your help.

I am using the VLOOKUP function but am having some trouble with it. I have
enetered in the formula and it works for a single cell, but when I copy it
down it changes the formula in a few ways and I come up with REF#'s.

Here is my formula for the first few cells which I have got to work by
editing the cell each time, but I cannot copy it down.

=VLOOKUP(B2,'Master List'!A2:B75,'Master List'!B1) WORKS!
=VLOOKUP(B3,'Master List'!A2:B75,'Master List'!B1) WORKS!
=VLOOKUP(B4,'Master List'!A2:B75,'Master List'!B1) WORKS!
=VLOOKUP(B5,'Master List'!A2:B75,'Master List'!B1) WORKS!

=VLOOKUP(B6,'Master List'!A6:B79,'Master List'!B5) DOSEN'T WORK :-(

Why is it that A2 changed to A6 and B75 to B79???

heres the next if it helps

=VLOOKUP(B7,'Master List'!A6:B79,'Master List'!B5)
=VLOOKUP(B8,'Master List'!A6:B79,'Master List'!B5)

Notice on the next it changes again! Now its A10 and B83???
=VLOOKUP(B10,'Master List'!A10:B83,'Master List'!B9)