IF, Index, Match formula

Crystal Panning

Hi,

I am trying to see if there is a formula that will look at the Cells in row 1, and if matched to the any of the weeks in column Week Of, will return the corresponding deliverable value in Column1. Attached is the clip of my smartsheet. Does anyone know if there is a formula that can do this? I have tried using IF, INDEX, MATCH, and have had no luck.

Thank you,

Crystal

Smartsheet.PNG

Bassam Khalil

Hi @Crystal Panning

Hope you are fine, please try the following formula ( note for each column you need to put the column name as a criteria).

=IFERROR(JOIN(COLLECT([Column1]:[Column1], [Week Of]:[Week Of], @cell = "Aug Wk1")), "")

The following screenshot shows the result:

Crystal Panning

Thank you for providing this formula to try. I think we are close, but when entering the formula in the cell, it shows up as blank. There is no error message, just the cell blank. It looked like it worked for you, so not sure why the cell shows blank for me. Any suggestions?

Smartsheet2.PNG

smartsheet3.PNG