Use the VLOOKUP function for it.

=VLOOKUP(nameyousearch,fulltableofdata,3,false)

For instance:

=VLOOKUP(E5,$A$2:$C$3,3,false)

PS: By the way, in the future please use a better topic title than "Excel".

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"ycwkpp898" wrote:

hi i need to get a simple yes or No from certain names eg
Name Amount Paid
andy 2.20 no
betty 3.30 yes

on my main sheet i have the following
Name Paid
andy
betty
in the paid column i want it to seach the top list and get the info from the
paid and put it in the main paid column.


please can anyone help


ty