Match Formula?

Hi,

I have attached a file where im looking to get data out of ColA.

Id like some Match formula perhaps? I need to get the detail in B,C,D & E out.

Can anyone sugegst anything?

Thanks
Seamus
Example.xls
Seamus2626Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
AmickConnect With a Mentor Commented:
I've attached an example solution.
Each line is tested to see if it holds the data we want to pull, if so we extract it.  
Data can be filtered on column B = True and column A&B can be hidden. ExampleSolution.xls
0
 
Seamus2626Author Commented:
Excellent. thank you very much Amick

Cheers,
Seamus
0
All Courses

From novice to tech pro — start learning today.