Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Vlookup from a drop down list
In Column A I have a drop down list from A17:A46
In Column B I have a formula =IF(A17="","",VLOOKUP(A17,'Hidden Pg for lookup Price'!A1:C29,2,FALSE)) this formula works for just the 1st row but if I copy it down it accelerates the rows =IF(A18="","",VLOOKUP(A18,'Hidden Pg for lookup Price'!A2:C30,2,FALSE)) I tried to put $'s around the $A$1:$C$29 but it then seems to freeze it up and will only show me the formula in the cell and not give me a result? Any ideas? Thank you!!!! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Vlookup from a drop down list
<I tried to put $'s around the $A$1:$C$29
That is correct. But the cell was formatted as text before you entered the formula. Format as Number or General AND re-enter the formula (F2, ENTER). Just re-formatting is not enough! -- Kind regards, Niek Otten Microsoft MVP - Excel "Heather" wrote in message ... In Column A I have a drop down list from A17:A46 In Column B I have a formula =IF(A17="","",VLOOKUP(A17,'Hidden Pg for lookup Price'!A1:C29,2,FALSE)) this formula works for just the 1st row but if I copy it down it accelerates the rows =IF(A18="","",VLOOKUP(A18,'Hidden Pg for lookup Price'!A2:C30,2,FALSE)) I tried to put $'s around the $A$1:$C$29 but it then seems to freeze it up and will only show me the formula in the cell and not give me a result? Any ideas? Thank you!!!! |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Vlookup from a drop down list
thank you so much !
"Niek Otten" wrote: <I tried to put $'s around the $A$1:$C$29 That is correct. But the cell was formatted as text before you entered the formula. Format as Number or General AND re-enter the formula (F2, ENTER). Just re-formatting is not enough! -- Kind regards, Niek Otten Microsoft MVP - Excel "Heather" wrote in message ... In Column A I have a drop down list from A17:A46 In Column B I have a formula =IF(A17="","",VLOOKUP(A17,'Hidden Pg for lookup Price'!A1:C29,2,FALSE)) this formula works for just the 1st row but if I copy it down it accelerates the rows =IF(A18="","",VLOOKUP(A18,'Hidden Pg for lookup Price'!A2:C30,2,FALSE)) I tried to put $'s around the $A$1:$C$29 but it then seems to freeze it up and will only show me the formula in the cell and not give me a result? Any ideas? Thank you!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup and drop down list | Excel Discussion (Misc queries) | |||
vlookup (a drop list) | Excel Discussion (Misc queries) | |||
Can I add a drop-down list to a Vlookup? | Excel Worksheet Functions | |||
Can I add a drop-down list to a Vlookup? | Excel Worksheet Functions | |||
Drop Down List + VLOOKUP | Excel Worksheet Functions |