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
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
