Matching location info by fid# to campaign name


New Member
Aug 27, 2014
Need a formula or macro to match up the fid# in Column B in Sheet1 (and its corresponding location data in the row) to the number within the Campaign name in column A in sheet2. Numbers that need to match are highlighted in red. Below data is only a small sample of the full list.


101 Arcadia815 West Naomi AvenueUnit #C&DArcadiaCA91007US7560(626) 445-9747
102Brea2500 E. Imperial Highway#124-4BreaCA92821US6122(714) 671-0995
103Downey8310 Firestone BoulevardDowneyCA90241US3842(562) 622-9230
104Glendale314-316 N. Glendale AveGlendaleCA91206US3758(818) 240-7800
105Lakewood4048 Hardwick StreetLakewoodCA90712US(562) 630-6704
106Irvine14415 Culver DriveIrvineCA92604US305(949) 857-8171
110Studio City12930 Ventura BoulevardSte. 226BStudio CityCA91604US2200(818) 990-6212
111 Torrance21203 Hawthorne BlvdUnit 107-39 BTorranceCA90503US5501(310) 316-3047
114Northridge18007 Chatsworth StreetGranada HillsCA91344US5608(818) 832-4955
115Huntington Beach7251 Warner Ave.Suite CHuntington BeachCA92647US5487(714) 841-1463
116 Culver City10814 Jefferson BoulevardSte. FCulver CityCA90230US4988(310) 253-5393
117 Montclair8801 Central Ave.Suite EMontclairCA91763US1657(909) 624-0058
118Riverside10560 Magnolia AvenueSuite FRiversideCA92505US1889(951) 359-2060
119 Whittier15030 Whittier BoulevardSte. 1WhittierCA90603US2070(562) 693-3761
121Ventura4255 E. Main StreetSuite 14VenturaCA93003US5283(805) 644-9902
122Thousand Oaks728-732 N. Moorpark RoadThousand OaksCA91360US3705(805) 494-4425
123West Hollywood100 North La Cienega Blvd.Suite A-105Los AngelesCA90048US1938(310) 358-0436



CampaignCompany NameAddressCityStatePostal CodeCountryPhone Number
Local: Springfield Centre: 2210Jenny Craig®
Local: Avondale Centre: 3209Jenny Craig®
Local: Tustin Centre: 167Jenny Craig®
Local: Green Tree Centre: 1253Jenny Craig®
Local: Countryside: 1704Jenny Craig®
Local: London Centre: 1901Jenny Craig®
Local: Edison Centre: 2030Jenny Craig®
Local: Herndon Centre: 4409Jenny Craig®
Local: Champions Centre: 3052Jenny Craig®
Local: Annapolis Centre: 3303Jenny Craig®
Local: Staten Island Centre: 2035Jenny Craig®
Local: Huntington Station Centre: 2045Jenny Craig®
Local: St. Catharines Centre: 1819Jenny Craig®
Local: Alexandria Centre: 4403Jenny Craig®
Local: Langley Centre: 1059Jenny Craig®
Local: Braintree Centre: 658Jenny Craig®
Local: Clackamas Centre: 454Jenny Craig®
Local: Hyde Park Centre: 1205Jenny Craig®
Local: Akers Mill Centre: 552Jenny Craig®
Local: Southshore Centre: 1971Jenny Craig®
Local: Glendale Centre: 3201Jenny Craig®
Local: Coral Springs Centre: 954Jenny Craig®
Local: West Chester Centre: 2213Jenny Craig®
Local: McLean Centre: 4411Jenny Craig®
Local: Fresno Centre: 3091Jenny Craig®
Local: Wayne Centre: 2027Jenny Craig®
Local: Palmdale Centre: 130Jenny Craig®
Local: Oviedo Centre: 1002Jenny Craig®
Local: Puyallup Centre: 417Jenny Craig®
Local: Columbia Centre: 3306Jenny Craig®
Local: Springfield Centre: 2025Jenny Craig®
Local: Westminster Centre: 3451Jenny Craig®
Local: Manchester Centre: 663Jenny Craig®


Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.


MrExcel MVP
Sep 18, 2013
Office Version
  1. 365
  1. Windows
Welcome to MrExcel.

Something like this perhaps:

B2: {=MATCH(" " &A2,RIGHT(E$2:E$5,1+LEN(A2)),0)} array-entered
C2: =INDEX(E$2:F$5,B2,2)

Or in one go, C2: {=INDEX(E$2:F$5,MATCH(" " &A2,RIGHT(E$2:E$5,1+LEN(A2)),0),2)}

Excel 2010
1FIDFindRowFindValueTable on another sheet
21302QSomewhere 555P
333064SPalmdale: 130Q
4Somewhere else 306R
5Columbia Centre 3306S

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
Upvote 0

Forum statistics

Latest member

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back