• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Look for a unique text sub-string & always return the last Col value in table.

SekharS

New Member
Hello Experts,

I have a Pivot table created from a realtime data source in "Pviot_Data" tab.

Each row in the Pivot will have be in this format:
Text1-Num1-Text2-Text3

I am trying to extract:
1. Text1 & Text3 in 'Pivot_Data' tab into separate Columns in 'Extracted_Data' tab. (Done)
2. Need to extract '2018 Total' in 'Pivot_Data' tab into "respective" 'Spend till Date' Columns in 'Extracted_Data' tab.

Note: Customer (or Text1) will always be unique.

In Summary, I am trying to look up Customer from 'Extracted_Data' tab in Col-B of 'Pivot_Data' tab & return the last Col value of 'Pivot_Data' always.

Hope I was able to explain myself.

Thank you in anticipation.

Best Regs
Seskhar
 

Attachments

  • Test_Data.xlsx
    13.8 KB · Views: 7
Perhaps this can work
D2=INDEX(Pivot_Data!$A$2:$ZZ$2000,MATCH(B2&"*",Pivot_Data!$B$2:$B$2000,0),MATCH("???? Total",Pivot_Data!$A$3:$ZZ$3,0))
 
Back
Top