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?