Hi


"Confused Man" wrote in message
...
Thank you that worked great... now a couple more questions if you don't
mind... right now if nothing is chosen in the pulldown list the Vlookup
returns #N/A. How can I get these cells to remain blank unless something
is
chosen from the list?

=IF(ISERROR(VLOOKUP(...)),"",VLOOKUP(...))
or
=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))


also, one of the Vlookup cells I want to multiply a manually entered value
but if I don't enter a value I want it to ignore that operation and just
return the value from the original dataset.

=IF(Multiplyer="",1,Multiplyer)*VLOKUP(..)


For example. Vlookup(B2,datatable,columns) should return a value of 1. but
it's looking at the cell I want to multiply and returning a 0, but I want
it
to ignore the cell if it's blank. I'm pretty sure I need to use an IF
statement, but I'm not sure how to go about that.


Arvi Laanemets