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

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"



"still confused" wrote in message
...
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...

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(VLOO KUP(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)),"",VLOO KUP(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...



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