Mr Excel

[mikereynolds]

Hello Mr Excel, please see below. I am trying to get the corresponding number to match the data in columns 2 and three in a batch manner if possible.
Any help would be appreciated. Cheers Mike

1​	100051210	100 FACTS: POLAR LANDS
	100051210	100 FACTS: POLAR LANDS
	100051210	100 FACTS: POLAR LANDS
	100051210	100 FACTS: POLAR LANDS
	100051210	100 FACTS: POLAR LANDS
	100074983	1000 INCREDIBLE BUT TRUE FACTS
	100078652	1000 INCREDIBLE FACTS ANIMALS
	100078652	1000 INCREDIBLE FACTS ANIMALS
	100074216	1001 QUESTIONS & ANSWERS
	100051761	101 DINOSAURS
2​	100078462	104-STOREY TREEHOUSE
	100078462	104-STOREY TREEHOUSE
	100078462	104-STOREY TREEHOUSE
	100078462	104-STOREY TREEHOUSE
	100078462	104-STOREY TREEHOUSE
3​	100085101	117-STOREY TREEHOUSE
	100085101	117-STOREY TREEHOUSE
	100085101	117-STOREY TREEHOUSE
	100085101	117-STOREY TREEHOUSE
	100041588	1915 AUSTRALIA'S GREAT WAR
	100049000	1916 AUSTRALIA'S GREAT WAR
	100049000	1916 AUSTRALIA'S GREAT WAR
	100049000	1916 AUSTRALIA'S GREAT WAR
	100062761	1917 AUSTRALIA'S GREAT WAR
	100061953	1918 AUSTRALIA'S GREAT WAR
	100061953	1918 AUSTRALIA'S GREAT WAR
4​	100081469	200 MINUTES OF DANGER
	100081469	200 MINUTES OF DANGER
	100044415	300 MINUTES OF DANGER
	100051386	3D PRINTING PROJECTS
	100051386	3D PRINTING PROJECTS
	100051386	3D PRINTING PROJECTS
	100051386	3D PRINTING PROJECTS
	100051386	3D PRINTING PROJECTS
	100051386	3D PRINTING PROJECTS

 

[Peter_SSs]

Welcome to the MrExcel board!

Your question is not clear to me. What is the expected result(s) for that sample data and how is it obtained manually?

I also suggest that you investigate XL2BB for providing sample data & expected results to make it easier for helpers to understand just what you have & where it is and also what you want & where it is to be.

A more descriptive thread title also usually helps getting faster responses.