vlookup again

[still confused]

thanks for yesterday's help, however, I can not seem to
arrange it to work for what I need. I tried to fill in
the info I am actually using, but I do not understand
enough programming to make it work.

my range is L2:M12
I am using 10 letters to represent numbers 1,2..8,9,0
those letters are to be typed in the "D" column, no more
than 6 consecutive letters (they will not represent a
value greater than $9,999.99

Please help...

 

[Andy Wiggins]

Have you looked in Excel's Help file? It has some EXCELlent examples.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"

 

[kkknie]

Here's what I worked out based on my post yesterday.

=VALUE(IF(ISNA(VLOOKUP(MID(D2,1,1),$L$2:$M$11,2)),"",VLOOKUP(MID(D2,1,1),$L$2:$M$11,2))&IF(ISNA(VLOOKUP(MID(D2,2,1),$L$2:$M$11,2)),"",VLOOKUP(MID(D2,2,1),$L$2:$M$11,2))&IF(ISNA(VLOOKUP(MID(D2,3,1),$L$2:$M$11,2)),"",VLOOKUP(MID(D2,3,1),$L$2:$M$11,2))&IF(ISNA(VLOOKUP(MID(D2,4,1),$L$2:$M$11,2)),"",VLOOKUP(MID(D2,4,1),$L$2:$M$11,2))&IF(ISNA(VLOOKUP(MID(D2,5,1),$L$2:$M$11,2)),"",VLOOKUP(MID(D2,5,1),$L$2:$M$11,2))&IF(ISNA(VLOOKUP(MID(D2,6,1),$L$2:$M$11,2)),"",VLOOKUP(MID(D2,6,1),$L$2:$M$11,2)))/100

I put it in E2 with the letters in D2. Also, the range is L2:M11 t
give the nubers 1,2,3...0 rather than L2:M12 as in you post.

Give it a whirl...