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

Index Function With Multiple Match Function

Ajju1234

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
 

Attachments

  • Book12.xlsx
    9.6 KB · Views: 2
Last edited:
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.
 
Back
Top