Skip to main content

Merge Different Data Sets Based on a Common Unique Field in Each Data Set

=IF(ISNA(VLOOKUP(C2,L:L,1,FALSE)),"FALSE",CONCATENATE("M",MATCH(C2,L:L,0)))

=IF(Q2<>"FALSE",INDIRECT(Q2),"")

Logo

Fairview Elementary School
Phone: 419 658-2511 | Fax: 419 658-2302
Address: 14060 Blosser Rd., Sherwood, Ohio 43556

Fairview Middle School
Phone: 419 658-2331 | Fax: 419 658-4010
Address: 06289 U.S. Highway 127, Sherwood, Ohio 43556

Fairview High School
Phone: 419 658-2378 | Fax: 419 658-4010
Address: 06289 U.S. Highway 127, Sherwood, Ohio 43556

Superintendent
Phone: 419 658-2808