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