Software

Ask something
Discussion Locked

Possible dropdown lists (Excel)

0 helpful
5 replies

by whatme?

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Trying to create a simple worksheet to calculate hourly billing allowable for a lawyer. I am working in excel and wonder if there is a way to #1- create a dropdown list within a dropdown list. In other words, pick an item in a list, which opens up another list to choose from. #2-When this item is chosen, that specific text would be calculated as a number in another cell.
Thanks... for more info email MTulloch@polarnet.ca

5 replies

by whatme?

Not too bad of sites but they don't actually do what I want. I can go another step and nest a dropdown. That is some help. What I need now is once I finally pick an item (text) in a cell, it will show a number in an adjacent cell
ex. apple = 2 ; orange = 5

by dklippert

Create a Table
Apple 2
Orange 5

Name the range "Groceries"

Then use a VLOOKUP function

If the word is in A1

=VLOOKUP(A1,Groceries,2,FALSE)

The first argument looks at the value then goes down the left hand column of the "Groceries" table until it finds an entry.
It then returns the value in the #2 column. FALSE makes sure it only returns an exact match.

This discussion is closed to new replies.