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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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)
 
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.
 
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
 
Back
Top