Matching values between column and row between sheets and returning corresponding value

First post. Struggling with this one.

On Sheet 1, I want to compare the week number from a column on sheet 1, to the week number in a row (row1) on sheet 2 and then return the value, in this case a symbol from row 4 on sheet 2 .

Sheet1 -

Sheet 2 -

Am only showing part of week number range. But in this case am I after - if week number on sheet 1 at cell row2 matches cell in week number row (row1) on sheet2, return symbol from cell at row 4 sheet 2. So return Green.

Is this possible. Tried Index/Match, but maybe could work with IF function? Any help gratefully received.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!