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