Found the answer on a different forum, Thanks for the suggestion Jeff
, here are the 2 codes that ended up working in case anyone was interested.
=IFERROR(LOOKUP(2,1/(MAX(IFERROR(ABS(IF('Power data'!$A$1:$A$2394=A2,'Power data'!$B$1:$B$2394,"")),""))=ABS(IF('Power data'!$A$1:$A$2394=A2,'Power data'!$B$1:$B$2394,""))),'Power data'!$B$1:$B$2394),"")
Attached is the code in action.
The other code that worked is this, it was able to be copied down and left which was nice.
=IF(MAX(ABS(INDEX(IF($A2='Power Data'!$A$2:$A$1397,'Power Data'!$B$2:$AE$1397),,MATCH(B$1,'Power Data'!$B$1:$AE$1,0))))=-MIN(INDEX(IF($A2='Power Data'!$A$2:$A$1397,'Power Data'!$B$2:$AE$1397),,MATCH(B$1,'Power Data'!$B$1:$AE$1,0))),MIN(INDEX(IF($A2='Power Data'!$A$2:$A$1397,'Power Data'!$B$2:$AE$1397),,MATCH(B$1,'Power Data'!$B$1:$AE$1,0))),MAX(INDEX(IF($A2='Power Data'!$A$2:$A$1397,'Power Data'!$B$2:$AE$1397),,MATCH(B$1,'Power Data'!$B$1:$AE$1,0))))
wish i could explain it but its way above my head but here it is none the less
Kevin