Hi,

Perhaps you can try something like this:

Excel 2013

A B C D 1 Original list Result column Lookup list 2 Phil Bauer Adam Pierce 3 John Smith PGC John Smith 4 Jodi Arlington Lisa Saxon 5 Adam Pierce PGC 6 Lisa Saxon PGC 7 Joe Fordham Sheet1

In B2 and copy down enter the formula:

Note, you must ensure the lookup list in column D is sorted in ascending order for this method to work.Code:=IFERROR( IF(A2 = LOOKUP(A2, D$2:D$4), "PGC", ""), "")

An alternative method that doesn't rely on the lookup list being sorted, might be something like this in B2 and copy down:

However this method will be significantly slower with a large list.Code:=IF(COUNTIF(D$2:D$4, A2) > 0, "PGC", "")

## Like this thread? Share it with others