Multiple If Commands

Hi everyone,

I have had a look on the forum for an answer to my problem and could do with some help.

I know a little about Excel but not a vast amount.

I am trying to select an item from a list in say A1 then A2 would automatically display the item description and A3 would display the price.

Is there a way i could do this.

Your help would be most greatly appreciated

Kindest Regards
Mark

Hi thanks for your post, i have visited the links and they explain further regarding the VLOOKUP tool i am still confused as a list is what i need. I understand about validation and how to put a list together but i'm unsure as to what code to use to tell B2 and C2 to put a result depending on the contents of A2.

Many thanks

Mark

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