hello guys,


need help creating a PROCV.


I have 3 sheets (clientes, stock and BD) and I need to go get information to 2 sheets (clientes and stock, if not found in one goes fetch the other), but one of the sheets (stock) i need the search corresponds to 2 tables, ie:

Sheet "Stock" - i need match of table A and B, and results in I
Stock.jpg

Sheet "Clientes" - i need match of table A and results in H

Clientes.jpg

Sheet "BD" - i need to match table A and B and paste the search results into table F

BD.jpg

You can see the code I've already created to look in two places, but I'm not getting you to search with two tables on the stock sheet.

Can you help me.