| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup instructions,, or help making a formula | Excel Discussion (Misc queries) | |||
| Making PMS-Histogram/S-curve for Progress REport from Primavera.. | Excel Discussion (Misc queries) | |||
| Deadline Notice | Excel Worksheet Functions | |||
| Active Deadline | Excel Discussion (Misc queries) | |||
| missing deadline | Excel Worksheet Functions | |||
![conditional format if cell contains word[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
