How do I pick value A from a list and have excel return value B?

G

Guest

I have a list of 30 names that have coded values. Since nobody has memorized
the coded values, I'd like the list to have the names and when you select the
name it displays the coded value. Example:

Column 1

A 'Monkey' (is on the list, but monkey is really 185.54)

When you pick Monkey from the list I would like the display to look like this:

Column 1

A 185.54

Any ideas?
 
D

Dave Peterson

How about creating a list on a different sheet (say sheet2), then use an
adjacent cell to return the numeric value for that name:

In B1:
=if(a1="","Pick a name",vlookup(a1,sheet2!a:b,2,false))
or
=if(a1="","",vlookup(a1,sheet2!a:b,2,false))

You could even hide the column with this formula, but still use that cell in any
subsequent calculations.
 
G

Guest

Briliant, thank you Dave.

Dave Peterson said:
How about creating a list on a different sheet (say sheet2), then use an
adjacent cell to return the numeric value for that name:

In B1:
=if(a1="","Pick a name",vlookup(a1,sheet2!a:b,2,false))
or
=if(a1="","",vlookup(a1,sheet2!a:b,2,false))

You could even hide the column with this formula, but still use that cell in any
subsequent calculations.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array Lookup to Find Closest Date and Next Closest Date 7
Vlookup+ Select Next Earliest Value (Array formula?) 1
Compare 2 lists and return value 2
Match Text return a value from the row 2
Formula (or code) return the largest number of duplicates in a list. 16
How do I delete duplicate cells? 1
With F1 value, look at A, if match or partial match return B 5
select from list and get value from another list 2

Top