Sorry the title isnt better.

My wife walks and house sits dogs and we are trying to set up excel so
she can invoice easily. I have created a drop down list of the 12
different dog services eg Walk and Water, House visit, House sit, Board
overnight etc, and that worls really well, however is there a way that
when you choose one of these items from the drop down list excel will
automatically show the charge for that service in another cell so that
you dont have to input it manually.

I have created a drop down list of the prices which is sort of a
halfway house at the moment.

Any help would be appreciated, thanks in advance!!

:) :)


--
tasadin
------------------------------------------------------------------------
tasadin's Profile: http://www.excelforum.com/member.php...o&userid=36979
View this thread: http://www.excelforum.com/showthread...hreadid=567383