Forum Discussion
Comparing multiple cells, if one cell has value, then name this cell another cell
Hi All, I am tracking manufacturing of items for a project. I have multiple variations of the same object. Example: I allocate which office cubicle is needing a particular type of filing cabinet. ...
Hi there!
Try to use this in cell B5:
=OFFSET(INDIRECT(CELL("address",INDEX(C5:G5,MATCH(1;C5:G5,0)))),-2,0)Change your ranges accordingly. The thing here is that you should change the row offset for each of the B column cells. That is, for B6, you should put -3 in the offset row count.
Martin
A touch of overkill using 365?
= BYROW(required?, LAMBDA(nReq?,
TEXTJOIN(", ",, IF(nReq?, nReq? & " x " & cabinateType, ""))
))where
cabinateType
=Sheet1!$C$3:$G$3
required?
=Sheet1!$C$5:$G$6
total
= BYCOL(required?, SUM)