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