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

  • Thread starter conditional format if cell contains word
  • Start date
C

conditional format if cell contains word

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)
 
H

Huber57

Put $ signs around the range.

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

Now drag copy down the column.
 
E

Eduardo

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
 
C

conditional format if cell contains word

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top