Multiple If Commands

**markswan20** · 01-17-2008, 03:21 PM

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

**NBVC** · 01-17-2008, 03:41 PM

You need to use Data Validation to create your drop down list....

see here for how: http://www.contextures.com/xlDataVal01.html#Create

Then you can use a Vlookup formula to get corresponding data from a table you have somewhere on the sheet.... see Vlookup in Excel help files for details.

**VBA Noob** · 01-17-2008, 03:44 PM

Try vlookup

http://datapigtechnologies.com/flashfiles/vlookup.html

http://www.auditexcel.co.za/lookupandreference.html

http://www.contextures.com/xlFunctions02.html

VBA Noob

**markswan20** · 01-17-2008, 04:17 PM

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

**VBA Noob** · 01-17-2008, 04:22 PM

You put the Vlookup in B2 and C2.

E.g

=vlookup(A1,Your Table,2,false)

Where
A1 is the lookup value
Your table range is the table of answers
2 is Column 2
False returns a exact match

So if you looked up Cat in A1 it would go to the table and if it found the word cat it would return what is in Col 2 of the table

VBA Noob

**markswan20** · 01-17-2008, 04:57 PM

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.