Data inputting question
 

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?

Data inputting question
 

There are many ways of achieving this. The most obvious at the moment,
given your lack of detail, would be to have a small table somewhere in
your sheet which lists names and amounts in two adjacent columns, and
then a VLOOKUP formula next to the cell where you enter your name, and
this formula will search through your table to look for the name you
have entered and return the corresponding amount.

Hope this helps.

Pete

On Jan 16, 4:01*pm, sha2312 wrote:
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?

Data inputting question
 

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/