Nested If Statement

[igmike]

I have attempted several functions Vlookup+IF, index/match. To complete step 1 in manipulating the given data for my purposes.

Sample data:


I no longer have the program that allows you to post excel data in a neat format to a forum post, nor could I find a reference in search. If someone could let me know, I can post data and desired solution.

Thanks in advance.

 

[igmike]

That I do. I will get back to you tomm. hopefully with more info, I appreciate your help, I spent 3-4 hrs hunting only to come close to part 1 of the solution.