Get starting and ending street number for each Street listed

I have attached a sample of the Street names with a listing for each street and the START LEFT, START RIGHT, END LEFT, END RIGHT , street numbers.

I have an old formula that has worked in the past, but can't seem to remember the steps. The formula returns a Street Name with the starting and ending street number, like ABC Street, 1000 to 1200 in two columns.

Here is old formula:

=AGGREGATE(15,6,($B$2:$E$6)*($A$2:$A$26=H2),SUMPRODUCT(--(($B$2:$E$26)*($A$2:$A$26=H2)=0))+1)
Min street range

=AGGREGATE(14,6,($B$2:$E$26)*($A$2:$A$26=H2),1)
Max Street Range


Thanks

i FIGURED IT OUT.