Multiple If Commands

Hi thank you very much it works great so easy when you have experts guiding you in the right direction.

One further thing how would i make it so that the fields in a2, a3 etc appeared blank until the information was inserted in a1?

Thanks very much for all your help.

Wow thank you, so much easier than i thought.

I have 1 final column with a total price in i get a #VALUE! when there is nothing entered in the fields containing the VLOOKUP fields

Is it possible to make this field invisible until the selection is made in A1?

I again thank you for your time and patience

kind Regards
Mark

Thank you for your very fast response,

I am manually entering a qty needed in a seperate column, this will be multiplied by the result in A4 my formula as =suma5*A4, when a value is displayed in a4 it works fine but when nothing is there it says #VALUE! this is my problem.
Apologies for not being slightly more specific.


Many Thanks

Mark

Thank you very much it works a treat,

Anyone reading this post will find it most helpful i did

Thanks Again

Mark :-)