Hi,

Say you have a list like below:

A B
1 Abbey $500
2 XXXXX $200
3 YYYYY $150

and you want when you write Abbey in a cell say C1 you can see the amount in
another cell say D1

enter formula below in D1

=VLOOKUP(C1,$A$1:$B$3,2,FALSE)

Thanks,
--
Farhad Hodjat


"SuzieinNC" wrote:

Kind of hard to explain so I will try to set an example:

Each time I type the word "abbey" into a cell, I would like for the next
cell to populate with a monetary value I have assigned. Is this possible??
If someone could just give me a little guidance I could figure it out.

Thanks!