Vertical Matching

Hello all,

I'm looking to do a "Vlookup" type function in that I want to find the Unique then sum up all of the data points the branch off to the right of that unique ID. Let me know if that makes sense. Example Below.

I want to match the correct PTN- Then SUM/Average the date changes across the 3 dates for that specific PTN.

PTN	Date 1	Date 2	Date 3
ABCD	1/10/17	1/15/17	2/15/17
DCBA	2/15/17	1/15/17	4/15/17
WXYZ	2/15/17	2/10/17	2/15/17

Thanks!

you can try this:
=IFERROR(SUM(INDIRECT("B"&MATCH($F$1,$A$2:$A$4,0)+1&":"&"D"&MATCH($F$1,$A$2:$A$4,0)+1)),"")

Okay, Thanks. I have attached a sheet. I want to pull the Data over to a new Sheet and the PTN's are constantly changing when I put the Data into the spread sheet so need to be able to Match it when i pull the data to the analysis tab.

So attach file where you show EXACTLY what you want, BEFROE sheet and AFTER sheet

The (B9) cell just represents the difference between the date changes divided by 4. I just need a number to quantify how large the change in dates is.

I will grab part of exactly what I need and re-post it and manually calculate my expected results, but you still wont understand the result I'm trying to achieve because its a metric that only will make sense in my company.

Yes, My math was wayyyy off on that one honestly I'm trying to come up with a better ratio for the end result right now.

something like this?
(I don't care about your math level )

Yup! That is basically what I'm looking for. I think I just need to figure out the correct math to track the deviation of the dates. If you see in the attached, there are times the dates don't change at all so I cannot just subtract the dates.

So you need to think more, define what exactly you want to achieve, create brand new detailed description and attach excel file which reflect data type and structure of your original work.

If that takes care of your original question, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you) then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED. Thanks.

Thank you. Yes, I still don't know what math to use to properly track it. You did answer my original question.

You are welcome, thanks & good luck