Hi guys,

I have no idea what I'm trying to do so I couldn't put it in the thread
title!

Basically I have a dropdown menu on a column from which you can choose
A, B or C

If you select A, I want 900 to appear in the adjacent cell

If you select B, I want 1,000 to appear in the adjacent cell

If you select C, I want 1,200 to appear in the adjacent cell.

So far I've got this... =IF(AA2="A","900","") but I can't figure out
how you can link these together so it will return a value for all 3
selections.

I think this is very simple and I'm sure I've done it before, but it's
driving me mad!

Thanks everyone!


--
monkeydan
------------------------------------------------------------------------
monkeydan's Profile: http://www.excelforum.com/member.php...o&userid=36982
View this thread: http://www.excelforum.com/showthread...hreadid=567038