And following on from the above, I want the formula in the second post
to also contain EURO values if 'Ireland' is selected in the first cell.
I guess this will use the AND function but as you are no doubt now
aware, I'm not too hot on Excel.

Thanks for any help you can give me.


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