V Look Up

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
 
K

kkknie

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.
 
Top