VBA - if three criterias match then copy/paste matching row value to another sheet

[VBwArrior]

Hello, I've problem with the code that is shown below. The thing is that I have criteria brought out in one sheet which contains three values.

Criterias in range of: sheets("Klaaside valik").range("A3:A11")

matching values in range of: sheets("Sheet1").range("B3:D7")

If all criterias match then I would like to have printed matching row value from column A to sheets("Klaaside valik").range("A14:A")

The code I've written:

Please Login or Register  to view this content.

Example file:

[sintek]

Help me understand...

Are you wanting to enter multiple items in Sheets("Klaaside valik") from range A3 to range C11 and search for all matches in sheet1 or just what is currently in row 3

[VBwArrior]

Hi, yes, I would like to enter multiple items, but in case I add just one then result would be for one...

Thanks!

[sintek]

Please replace your current uploaded file with one that has the results expected posted....

Give two entries at least...with the results...

[VBwArrior]

Did that, copy-copy is for you.

[jindon]

Try

Please Login or Register  to view this content.

[VBwArrior]

There is still one problem...

For example if I select "Insulated unit" that match with criteria and "insulated unit max thickness" that doesn't match then it still prints the name.

basically the output should be the list that matches to every criteria.

Is it possible to solve that?

Thank you in advance!

[jindon]

I don't understand what you are talking about.

If you clear all the criteria and just select "insulated unit max thickness" in A3, with 3000, 2000, it clears the result.

[VBwArrior]

If I select max thickness or weight, it doesn't give any result.

[jindon]

If you upload a workbook with the criteria and the EXACT result that you want, it may hel@.

[VBwArrior]

Everything OK now, I just needed to fill empty cells with zeros.

Thanks!