Thread: [Solved] Need formula to sequentially look in three columns and return calculation if column is populated.
View Single Post
 
Old 08-30-2024, 12:40 AM
kvsrinivasamurthy kvsrinivasamurthy is offline Windows XP Office 2007
Novice
  
Join Date: Oct 2017
Posts: 12
kvsrinivasamurthy is on a distinguished road
Default
In C2,

=BYROW(A2:C7,LAMBDA(x,IFERROR(88*INDEX(x,AGGREGATE (14,6,COLUMN(x)/(x>0),1)),"")))

Or

=MAP(A2:A7,B2:B7,C2:C7,LAMBDA(x,y,z,IF(z>0,88*z,IF (y>0,88*y,IF(x>0,88*x,"")))))

For other versions in C2 copied down

=IFERROR(88*@INDEX($A2:$C2,AGGREGATE(14,6,COLUMN($ A2:$C2)/($A2:$C2>0),1)),"")
Reply With Quote