Issue Not able to get Min-Max of parts using formulas, shows wrong value

What I did

Here is my formula

=MAX(VLOOKUP(A2,TAT!A:C,3,FALSE))& "/" &MIN(VLOOKUP(A2,TAT!A:C,3,FALSE))

Here is sheet 1

Here is sheet 2

Results that I want? Basically, I just want the Min-Max from TAT sheet to be shown in BER Summary Sheet in the Min-Max TAT column. What I want it to show

Is something wrong with the formula or am I not using the right approach to the formula at all?

CodePudding user response：

In Office 365:

=MAXIFS(TAT!C:C,TAT!A:A,A2)& "/" &MINIFS(TAT!C:C,TAT!A:A,A2)