Multiple Criteria Index/Match Function in VBA Looking Up Dates/Strings/Numbers

I cannot seem to get this to work and i am hoping one of the resident experts can shed some light on what i am doing wrong.

Essentially, I am trying to use a combination of Index and Match functions from within VBA to identify multiple criteria and then return a related value from another column in the identified row. I have attached a sample file with the following 2 simple scenarios:

On a Userform are 2 scenarios:

Single Criteria [WORKING] - Selecting a date from the top combobox triggers the macro to match the selection with a column on the "Raw Data" sheet. It if there is a match it puts the corresponding value from column C ("Flag") into the top label on the userform.

Multiple Criteria [NOT WORKING] - Selecting a date from the bottom combobox triggers the macro to match the selection with a column on the "Raw Data" sheet. It also attempts to match a string (stock symbol) from the "Main" worksheet in A2 to a column on the "Raw Data" worksheet. The bottom label on the userform should only show a value if both criteria are met.

After spending some time on this and learning about the behavior of the Match function in VBA i think i have gotten very close... but i am still missing something. Hopefully it is syntax related. Any help would be greatly appreciated!

Single Criteria Code[Working]:

Please Login or Register  to view this content.

Multiple Criteria Code [Not Working]:

Please Login or Register  to view this content.

Hi Pierre,

Thank you for your response.

You are correct that i am already limiting the date values that get populated into the userform comboboxes based on that symbol from the "Main" worksheet. And i realize that my code may be primitive as i go about trying to achieve what i want but this is just how i am trying to muscle through it.

I am pulling this functionality from a larger more complex project, but basically assume there would be a listbox on the main page with a bunch of stock symbols in it. The user selects one and then has some various menus (userforms) that can be brought up with supporting information based on whatever stock symbol is selected. The Raw data worksheet could have 10,000 rows of data for 100 different stocks. I want to be able to query that large data set(like you would in Access) by multiple criteria. So my thinking is, I have a symbol highlighted in a listbox on the main sheet which is one of the criteria I wish to use. I bring up a userform that allows me to select a second criteria related to that highlighted symbol (The unique dates that were added through the No Dupes collection). I then wish to query the raw data sheet using both pieces: the symbol from the main sheet and the date (or whatever) from the userform combobox. I want the result (the flag in this case) to appear in the label on the userform.

So if for example you insert a row between 1 & 2 on the raw data sheet and put an identical date with a different symbol and flag(say "AAPL" & "N"), the userform combobox macro would see the date and return the wrong flag because it wasnt also referencing the selected symbol criteria from the main sheet.

It sounds simple in my head and when i write it out like this... but i am having trouble getting it to work.