vlookup on 2 sheets for min or max date in an adjacent column

[m09151014]

I have a workbook with 3 sheets (sheet1, sheet2, sheet3) sheet1 has stores numbers in column A. Sheet2 and sheet3 also have store numbers in column A. I need it to find the store number in sheet2 or/and sheet3 for the store number in column A then give me the min or max date that corresponds with store number in column A in column E on sheet2 or sheet3. Is that possible?

 

[m09151014]

I can get the MAXIFS one to work. For a value of sheet 1 in row 3, this formula seems to work:
=MAX(MAXIFS(Sheet2!E:E,Sheet2!A:A,Sheet1!A3),MAXIFS(Sheet3!E:E,Sheet3!A:A,Sheet1!A3))

MINIFS seems to be a bit more challenging, as when it is not found, it is returning a zero.
However, if what you say here is really true:

Then we could to this (for an entry on Sheet1 in row 3):
=MINIFS(Sheet2!E:E,Sheet2!A:A,Sheet1!A3) + MINIFS(Sheet3!E:E,Sheet3!A:A,Sheet1!A3)

But I see that "3" appears in column A on both Sheets 2 and 3 in your example.
Not sure if that is a typo, or what you said about the number won't appear on both sheets is incorrect.

Yes 3 on both sheets was a typo.
BOTH worked!!!!! You have no idea how many days I have worked at this issue and how many Youtube videos I have watched!!! I could cry I am so happy gonna message my boss and tell him I am taking the afternoon off!!!

 

[CA_Punit]

Even if they appear in both the sheet you can consider post 9.

Also for 1 in Max 08/04/2020 but in Sheet 3 for 1 you have max as 08/07/2020????

 

[sandy666]

another approach with Power Query

Sheet 2			Sheet 3			Result
No	Date		No	Date		No	Min	Max
3	08/08/2020		1	10/07/2020		1	10/07/2020	14/07/2020
3	08/09/2020		1	11/07/2020		2	15/07/2020	19/07/2020
3	08/10/2020		1	12/07/2020		3	20/07/2020	08/11/2020
3	08/11/2020		1	13/07/2020		4	08/04/2020	08/04/2020
4	08/04/2020		1	14/07/2020		5	08/06/2020	08/06/2020
5	08/06/2020		2	15/07/2020
			2	16/07/2020
			2	17/07/2020
			2	18/07/2020
			2	19/07/2020
			3	20/07/2020
			3	21/07/2020
			3	22/07/2020
			3	23/07/2020

let
    Src1 = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Src2 = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    App = Table.Combine({Src1, Src2}),
    Group = Table.Group(App, {"No"}, {{"Min", each List.Min([Date]), type datetime}, {"Max", each List.Max([Date]), type datetime}}),
    Sort = Table.Sort(Group,{{"No", Order.Ascending}}),
    Type = Table.TransformColumnTypes(Sort,{{"Min", type date}, {"Max", type date}})
in
    Type