Excel

[ycwkpp898]

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

 

[Wigi]

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".

 

[Don Guillett]

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

 

[ycwkpp898]

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