karlux_lip
10-26-2021, 04:15 AM
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
29095
Sheet "Clientes" - i need match of table A and results in H
29096
Sheet "BD" - i need to match table A and B and paste the search results into table F
29097
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.
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
29095
Sheet "Clientes" - i need match of table A and results in H
29096
Sheet "BD" - i need to match table A and B and paste the search results into table F
29097
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.