Matching

Matt · Mar 27th, 2002, 03:00 AM

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 · Mar 27th, 2002, 03:10 AM

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 · Mar 27th, 2002, 03:15 AM

Cheers Dave

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 27th, 2002, 03:00 AM	#1
Matt Board Regular Join Date: Feb 2002 Location: England Posts: 212	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

Mar 27th, 2002, 03:10 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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.

Mar 27th, 2002, 03:15 AM	#3
Matt Board Regular Join Date: Feb 2002 Location: England Posts: 212	Cheers Dave