Matching

[Matt]

I have a list of regions in column D and a list of regions in column A, some regions are present in both lists, some not. I want to transfer the corresponding region values in column B to column E, e.g. look at region in D2, does it appear in list in column A? If so, return corresponding value in column B to E2. Hope someone can help.

Thanks

Matt

 

[Dave Hawley]

Hi Matt

In cell E1 put:

=IF(COUNTIF($A$1:$A$1000,D1)<>0,VLOOKUP(D1,$A$1:$B$1000,2,FALSE),"")

Copy down as far as needed. Then sort Column Column E to move empty text to the bottom.

 

[Matt]

Cheers Dave