• 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.

extract value based on primary number

mohan08

Member
Hi All,

Can you help with formula with the attached report?

I have raw data with primary number, secondary number and shop, I need to convert the raw data input into output available on sheet 2.

Thanks

Mohan
 

Attachments

  • Sample.xlsx
    10 KB · Views: 4
Try,

1] In B1, copied across right to F1:
=IFERROR(INDEX(Sheet1!$B$2:$B$35,MATCH(0,INDEX(COUNTIF($A1:A1,Sheet1!$B$2:$B$35),0),0)),"")

2] In B2, copied across right to F2:
=IFERROR(INDEX(Sheet1!$C$2:$C$35,MATCH(B1,Sheet1!$B$2:$B$35,0)),"")

3] In B3, copied across right to F3 and all copied down :
=IFERROR(AGGREGATE(14,6,Sheet1!$A$2:$A$35/(Sheet1!$B$2:$B$35=B$1),ROWS($1:1)),"")

Regards
Bosco
 

Attachments

  • Primary number Lookup.xlsx
    13.4 KB · Views: 6
Back
Top