Choose from drop down menu and get defined output in another cell

N

NWCrane

I have created a drop down menu with several different options included in
it. If I select one of the options, I want a value that I predetermine to
display in the cell next to it. Is there any way to do this?
 
B

Bob Phillips

Won't a simple IF function on that value do it?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
N

NWCrane

I cannot seem to find what I am looking for in vlookup. I am not sure if my
description of what I am trying to do is making sense so I will reword it.

I have created a dropdown menu of different pay scales our company has.
When I select one of the pay scale names from the drop down menu, I want the
wage that corresponds with that scale to come up in the cell directly
adjacent to the right.

Thank you for any help you can provide.
 
T

Toppers

Create table with pay scales (names and wages) say in Sheet2 columns A & B

With drop down in A2 of sheet1:

in B2:

=VLOOKUP(a2,Sheet2!a:b,2,0)

HTH
 
Top