Data inputting question

[sha2312]

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?

 

[Pete_UK]

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

 

[Stan Brown]

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.