V Look Up
 

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

V Look Up
 

This is the formula:

=VALUE(VLOOKUP(MID(M3,1,1),O3:P28,2)&"."&VLOOKUP(M ID(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.



--
Message posted from http://www.ExcelForum.com