Hi

That's a different scenario.
Try
=IF(RIGHT(A1)="M","Multi","Single")

--
Regards
Roger Govier



"BrianH" wrote in message
...
Let me give some more info. On sheet 2 I have entered 10 items in cells
B2 -
B11. I created a list box for them on sheet 1 is cells B2 - B22. This is
whats in my list box.

$65.00 S
$65.00 M
$100.00 M
$125.00 S
$125.00 M
$240.00 S
$350.00S
$350.00 M
$500.00 S
$800.00 M

The S means Single and the M means Muti. So If I chose $500.00 S, I want
it
to populate the next cell with the word Single.

"BrianH" wrote:

I have a real simple worksheet that has a list box of 10 items. When I
choose
one of the items from the list I want it to auto fill the next cell with
a
amount.
If I pick $100 from the dropdown list, I want it to populate the next
cell
with 15.
$100 - 15
$200 - 30
$300 - 45