Need formula to sequentially look in three columns and return calculation if column is populated.

		Microsoft Office Forums > Microsoft Excel > Excel
Need formula to sequentially look in three columns and return calculation if column is populated.

FAQ

Thread Tools

Display Modes

08-30-2024, 12:40 AM

kvsrinivasamurthy kvsrinivasamurthy is offline

Windows XP Need formula to sequentially look in three columns and return calculation if column is populated.

Office 2007

Novice

Join Date: Oct 2017

Posts: 12

kvsrinivasamurthy is on a distinguished road

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)),"")

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Counting populated cells (range) in one column, that fall between 2 (diff) values in another column	SnakeDoctor	Excel	17	08-02-2024 08:39 AM
Whats the correct formula to point to the last populated cell in a column?	oscarlimerick	Excel	4	03-09-2021 08:00 AM
Excel / Mail Merge - Return Column Headers for All and Any Columns with Values	eduams	Mail Merge	1	09-26-2016 07:02 PM
Formula/function to return column names for matching values	GiJoe81	Excel	1	06-27-2015 12:13 AM
Need to search a column for a macth and return a result from a third column	pdfaust	Excel	2	02-03-2011 03:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:11 PM.