Vertical search with multiple tabs and multipple values

Hi,


I would like to write a code that returns value in the cell that is a few colums next to a unique combination of 2 cells.

For example you have 3 columns in tab1

NUMBER | NAME | PRICE


and you have multiple columns in tabs 1 to 50 with

ORDERNR. | NUMBER | NAME | QUANTITY | PRICE


In tab 1, number and name are filled in but we need to find the price in the tabs.

Nor number, nor name are unique, only the combination is.

So I need to do a search in the tabs to get the price, it's like a vertical search but with two values, multiple tabs.

sample.xlsx

Hope it's enough to understand the problem