Ok i have my various options in my list that can be chosen from, however
i want whatever is chosen to display a unique price in the next cell -
how can i do this?

I know an IF statement will check the list cells properties and display
a price if the cell matches the statement, but i can only do this for
one selection so far

please help!

Thanks!


--
tomrobs
------------------------------------------------------------------------
tomrobs's Profile: http://www.excelforum.com/member.php...o&userid=16127
View this thread: http://www.excelforum.com/showthread...hreadid=275661