Hi guys, i'm new to VBA and my goal is to make a form where i can selec some values in 4 diferent ComboBoxes and it shows me a value from a table i have , using a multiple criteria search(use the values given in the comboboxes to search for another in the table). The table is like that(but much bigger) Polymer Flow Product Mode Application Pc 7 Xxx Injection Automotive Abs 7 Yyyextru Extrusion General Pbt 12 Xyx Extrusion UV Pc 30.5 Yyx Injection FDA i want to give insirt the polymer, flow , mode and application click " search and recieve the product. I did that using Index Match in excel , but i want to use VBA , so after some research i tried some codes and it is not working. Can someone help me? i'm toltally open and would be grateful, i'm new to this. (The sheet i use is Planilha2 ("index" ))

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Index Match multiple criteria in VBA

Thread starter beheld_bird
Start date May 9, 2023

beheld_bird

New Member

May 9, 2023

Hi guys, i'm new to VBA and my goal is to make a form where i can selec some values in 4 diferent ComboBoxes and it shows me a value from a table i have , using a multiple criteria search(use the values given in the comboboxes to search for another in the table).

The table is like that(but much bigger)

Polymer	Flow	Product	Mode	Application
Pc	7	Xxx	Injection	Automotive
Abs	7	Yyyextru	Extrusion	General
Pbt	12	Xyx	Extrusion	UV
Pc	30.5	Yyx	Injection	FDA

i want to give insirt the polymer, flow , mode and application click " search and recieve the product.

I did that using Index Match in excel , but i want to use VBA , so after some research i tried some codes and it is not working. Can someone help me?

i'm toltally open and would be grateful, i'm new to this.

(The sheet i use is Planilha2 ("index" ))