How to create a looking based on 3 fields

[DCHOBO]

Hi,

Can someone point me in the right direction with what I want to do:

I know how to use data validation to create drop downs which is phase 1.

How do I cause a result to occur based on what was chosen

e.g.

Col A = (user chooses ABC)
Col B = 80 (because ABC was choosen)

Sheet 2 will have the 'list' to choose from, so it's got all the values
in a Column for the user to choose from.

E.g.

Col A = ABC
Col B = $90

Let me know if I haven't explained what I want to archive correctly.

 

[Dave Peterson]

It sounds like you can use =vlookup() or =index(match()) to retrieve the
assocated value.

Put your table in another sheet (sheet2 (and hide that sheet???)).

Then use a formula like this:
=if(a1="","",vlookup(a1,sheet2!a:b,2,false))

Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble

 

[DCHOBO]

It sounds like you can use =vlookup() or =index(match()) to retrieve the
assocated value.

Put your table in another sheet (sheet2 (and hide that sheet???)).

Then use a formula like this:
=if(a1="","",vlookup(a1,sheet2!a:b,2,false))

Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble

Ah that's it!!! thanks muchly!