Excel

Y

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
 
W

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

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
 
Top