Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|