CODEWITHSUNDEEP
excel-formula
IdRatherBeGardening
IdRatherBeGardening

Reputation: 65

Excel formula needed: see if a text in one column appears in a second column

I need a formula that will search for an exact match to A1 in B1:B3, if it finds a match in will a return "yes" on Col C. See example

     A         B       C
1    abc      bcd      yes
2    dfg      fgh      no
3    adf      abc      no

Upvotes: 0

Views: 142

Answers (1)

Joe DeRose
Joe DeRose

Reputation: 3558

Enter the following in cell C1. Then copy down:

=IF(ISERROR(VLOOKUP(A1,$B$1:$B$3,1,FALSE)),"no","yes")

Upvotes: 2

Related Questions