Hi guys, looking for a bit of help here. What I want is to have a cell,
let's say it's A1, have a drop down menu within it. No proble, I got that
part all figured out.

Then I want another cell, let's say B1in which is entered a numerical value.
Again, I got that part. :-)

The trick is that I want yet a third cell, say C1, to basically "read" the
choice made in cell A1, combine it with the numerical value entered in B2,
and then automatically fill in a preset string based on what A1 and B2 say.
I'm not looking for a mathematical formula, because the data in A1 is text
from the drop down, the data in B2 is numerical, and the data in C1 is also
text, based on the particular combo of items in the other 2 cells.

Any help here is GREATLY appreciated.

Shane