To answer your last question first, in a blank Excel sheet put this

formula in A1:

=CHAR(ROW())

then copy it down to row 255. Highlight all those cells, and format

using the Wingdings font - you can see the character number (as the

row identifier) against each character. You can easily try other

symbol fonts to see what they look like.

Now back to the original question - assume A1, B1 and C1 are the

dropdowns. In another area of the sheet (eg X1:Y30) you can set up a

table like this:

AAA 252

AAR 251

AAD 234

ARA 252

ARR 251

ARD 234

RAA 252

RAR 251

RAD 234

RRA 252

RRR 251

RRD 234

DAA 252

DAR 251

DAD 234

DRA 252

DRR 251

DRD 234

AA 252

AR 251

AD 234

RA 252

RR 251

RD 234

DA 252

DR 251

DD 234

A 252

R 251

D 234

which represents all possible combinations of the first letters of the

three columns and the character code that you want for each

combination (based on the last letter). Then in D1 you can put this

formula:

=IF(A1&B1&C1="","",CHAR(VLOOKUP(LEFT(A1)&LEFT(B1)&LEFT(C1),X$1:Y

$30,2,0)))

Format the cell as Wingdings, then try it out by changing the values

in A1, B1 and C1.

The table and VLOOKUP formula avoids having multiple IFs.

Hope this helps.

Pete