Forum Discussion
Solved
search between columns
I has this truncate table show below: Device is from 1 to few hundreds. Vref is from 1.0 to 5.0 Current starts from 0 then having some values and then goes down to 0. I need to return a Vref valu...
Depends on which Excel you are. For 365 it could be
with
=IFNA( IF({1,0}, FILTER($B$4:$B$33,($C$3:$C$32=0)*($C$4:$C$33<>0)), FILTER($B$4:$B$33,($C$4:$C$33<>0)*($C$5:$C$34=0)*($C$5:$C$34<>"")) ),"")
Depends on which Excel you are. For 365 it could be
with
=IFNA(
IF({1,0},
FILTER($B$4:$B$33,($C$3:$C$32=0)*($C$4:$C$33<>0)),
FILTER($B$4:$B$33,($C$4:$C$33<>0)*($C$5:$C$34=0)*($C$5:$C$34<>""))
),"")