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

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

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