• 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


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

Index Function With Multiple Match Function


New Member
How can i use Index Function with Multiple Function
In this case consignee customer are taking from 2 buyers but both 2 buyers are belongs to different persons.
i have attached sheet for more explanation.
can anyone help


Last edited:


Active Member
a little more info

you can use & to join 2 or more elements and ranges

or a grid lookup - using index( , match() , match()

but a sample spreadsheet would help here

A SMALL sample spreadsheet, around 10-20 rows, would help a lot here, with all sensitive data removed, and expected results mocked up and manually entered, with a few notes of explanation.