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

Lookup

S

Shabbo

Member
Dear Sir,

Reference to attached sheet I wanted to analyse my data like below mentioned.

Shee1 is my working sheet and sheet 2 is my final sheet

I wanted to know whether my Invoices numbers are same as per sheet 1 in front of reference numbers in sheet 2.

Eg : MYIN-001 should have Invoices like Inv no 1 to Inv no 5.

I tried v lookup but I looked up only 1st value
 

Attachments

  • MY INVOICES.xlsx
    9.1 KB · Views: 5
Would a Pivot Table work for what you want? They're really handy for the type of output you seem to be wanting.
 

Attachments

  • MY INVOICES.xlsx
    13 KB · Views: 1
Hi,

You can use a combination of INDEX, SMALL and IF to do that... it will return all matching results for a specific criteria (in this case the "Reference Number").

Please refer to the attachment and let me know if this works for you.

I hope this helps.
 

Attachments

  • MY INVOICES.xlsx
    10 KB · Views: 7
Another option in using combination of VLOOKUP, OFFSET and IF.....

Please see attachment

Regards
 

Attachments

  • MY INVOICES (2).xlsx
    10.2 KB · Views: 4
You must log in or register to reply here.
Back
Top