Wed, 16 Jan 2008 08:01:01 -0800 from sha2312 <sha2312
@discussions.microsoft.com:
Am I able to set my workbook up so that when I enter a certain name say Bob
that an amount ie £50 appears in the next field?

If you're entering Bob in A1, and by "next field" you mean A2, then
this formula in A2 will do it:

=if(A1="Bob",50,"")

and format A2 as currency.

But this question is *so* specific that I doubt it's what you really
meant to ask.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/