If Statement Issues

[mcgoo]

So I have a list of names of all people.

Another list of people that have talked to me.

I want to prepare an if statement that searches through the entire list of those who have talked to me and place text next to those who haven't on the List of all people.

I have this =IF(K5=B5:B34, "Ride","Need Ride")

K column is the list of all people
B column is the list of those who have talked to me

any suggestions?

 

[jmthompson]

One possibility:

=IF(ISNA(VLOOKUP(K5,B$5:B$34,2,FALSE)),"Need ride","Ride")

 

[Scott Huish]

=IF(ISNUMBER(MATCH(K5,$B$5:$B$34,0)),"","Need ")&"Ride"

 

[mcgoo]

Fantastic it worked thank you very much for your help!