Excel - Best Way To Perform Lookup In This Case?-CodePudding

I have a dataset (See attached)

However, I would like the Date Posted In Transpose Format, So I used transpose and pasted into another sheet. (See attached) But how do I populate the data for FB and TWTR respectively?

CodePudding user response：

Pivot: Excel Formula

Sum

If you want to sum up the Hi column, then you can use the following formula:

=IFERROR(SUMPRODUCT(Sheet1!$C$2:$C$25,(Sheet1!$A$2:$A$25=C$1)*(Sheet1!$B$2:$B$25=$A2)),"")

Match

If you want to find the first occurrence i.e. there is only one Date/Symbol combination or the Hi column contains text, then you can use the following array formula:

=IFERROR(INDEX(Sheet1!$C$2:$C$25,MATCH(1,(Sheet1!$A$2:$A$25=C$1)*(Sheet1!$B$2:$B$25=$A2),0)),"")