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

Will Vlookup do?

adamuce

Member
Hi

I am wondering if vlook up will solve this issue when matching a number of criteria with a range of data. Trade If so can someone please tell me how.

Lets say I want to know the weight (marked red cell I2) based on Exporter: Japan (cell F2) and Importer Importer Korea (cell G2) of Product Wood (cell H2) from the data range column A to D.

I have provided and excel file and a photo for reference to the scenario above https://ibb.co/dJzyPpZ
 

Attachments

  • Trade.xls
    25.5 KB · Views: 4
hello
you can to Use this Array
Code:
=INDEX($D$2:$D$600,MATCH(1,($A$2:$A$600=F2)*($B$2:$B$600=G2)*($C$2:$C$600=H2),0),0)
press Ctrl+Shift+Enter Not Enter only As Usual
 

Attachments

  • Trade1.xls
    31.5 KB · Views: 2
Back
Top