HELP PLEASE - SEARCH FORMULA

[Paulo Delgado]

Hello Excel Masters!

Could you help me please?

I attached an excel file were i would like some help.

On this excel i have 2 sheets.

On the first sheet i will add diferent stp.sale dates with different symbols under specific date of the month.

On the second sheet i want that under the date of each month, the most actual symbols filled on the sheet 1, must appear on the sheet 2 based on the actual date.

So on the sheet 2 should appear under the month date the correspondent symbol on the sheet 1 based on the most actual date, type and agency.

This will allow that when i fill the sheet 1 with different agencies, different types and different dates, on the sheet 2 will appear only the most actual date inserted and the correspondent type and symbols correspondents will appear.

Is difficult to explain in english for a portuguese guy!

But any questions, i will try to clarify.

Many thanks in advance!
Paulo

 

[vletm]

Paulo Delgado
You would add more data to 1-sheet and also show expected results in 2-sheet.

 

[Paulo Delgado]

Yes, i will be adding more info in 1 sheet and the 2 sheet will be updated with the most actual information from 1 sheet.

thank you

 

[vletm]

Paulo Delgado
Could You add more data to that file now and
also show (fill manually) expected result to 2-sheet?
After those,
would You upload that file here?
Then everyone would see, what are You looking for.

 

[Paulo Delgado]

Now i understand what do you need,

so in attachment you will find the expection file.

thank you in advance for the help.

best regards

 

[vletm]

Paulo Delgado
This would give the latest information from 1-sheet.
How should 2-sheet's yellow information effect to the result?

 

[Paulo Delgado]

Hello,

the information on the sheet 2 will afect because on the sheet 2 could be a different information and on the sheet 1 could be filled with other information too, so when the sheet 2 have the information on yellow, the formula should search that information, if on the sheet 2 is other information, the formula should search the new information.

is difficult to explain

 

[vletm]

Paulo Delgado
It's challenge to get exact result if 'it's difficult to explain'.
I could only guess ...
Now, all 2-sheet's yellow information effects to result.
... but Your sample result won't match with it!

 

[Haz]

You could also try this formula
=IFERROR(INDEX('1'!$D$4:$J$10, MATCH(1, INDEX(1 / ('1'!$A$4:$A$10<=$B$2) * ('1'!$B$4:$B$10=$B$1) * ('1'!$C$4:$C$10=$B$3),)), MATCH(C$3, '1'!$D$3:$J$3, 0)), "")

 

[Paulo Delgado]

You could also try this formula
=IFERROR(INDEX('1'!$D$4:$J$10, MATCH(1, INDEX(1 / ('1'!$A$4:$A$10<=$B$2) * ('1'!$B$4:$B$10=$B$1) * ('1'!$C$4:$C$10=$B$3),)), MATCH(C$3, '1'!$D$3:$J$3, 0)), "")

Thank you!