ty so much and sorry for the title

that works but on my sheet i have data that on maybe some look like this
Name Amount Paid
andy - -
andy 2.20 no
andy 2.20 no
betty 3.30 yes

and displays - in the cell. is there a way i can make it look at all of say
andy and it show yes or no as the next row it has a yes.

if possible

ty sooooo much for the help


"Wigi" wrote:

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