V Look Up

  • Thread starter Thread starter Really Confused
  • Start date Start date
R

Really Confused

Alert! first time user...

How do I create a "table" with letters equalling
numerical values that a VLOOKUP function will decifer?
Example: if Cell D3 has "abc" and the created table
(O3:P11) is set up as O3=a, P3=1, and O4=b, and P4=2, and
so on, how do I make the value of D3 to go from abc to
$1.23?

Please advise
 
This is the formula:

=VALUE(VLOOKUP(MID(M3,1,1),O3:P28,2)&"."&VLOOKUP(MID(M3,2,1),O3:P28,2)&VLOOKUP(MID(M3,3,1),O3:P28,2))

Using M3 as the cell holding abc. Format the cell as currency and yo
should have it.
 

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

Back
Top