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

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

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

It appears that SUMIF should do what is needed. Look in the help index.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ycwkpp898" wrote in message
...
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