I have two tables in two different sheets that I need to use to combine info.
Sheet 1 - Table 1:
A | B | C 12-2-19 | Monday | Function Needed here 12-3-19 | Tuesday | Function Needed here 12-4-19 | Wednesday | Function Needed here 12-5-19 | Thursday | Function Needed here 12-6-19 | Friday | Function Needed here
Sheet 2 - Table 2:
A | B Monday | text1 Tuesday | text2 Wednesday | text3 Thursday | text4 Friday | text5
Basically where it says Function Needed Here (Col C Sheet 1) I want it to pull in text1, text2, etc. (Col B Sheet 2) based on the day of the week (Col B Sheet 1)
My idea was to use a functionlike this in Col C of Sheet 1:
=IF(B1='Sheet 2'!A1,'Sheet 2'!B1,"--")
But that only checks for Monday (and works) but I want to have it check all the days and return the corresponding text.
How can I have it check the entire range of Col A Sheet 2 for the value in Col B Sheet 1 and return the corresponding value in Col B Sheet 2 to Col C Sheet 1.
NOTE: Sheet 1 is going to be a calendar and have all the dates/days of the week for the entire month of December. There will also be corresponding sheets for January, February, March, etc. so the formula needs to always default to the static range in Sheet 2 Cols A&B Rows 1-5. Only the rows in Col B and C in Sheet 1 will change dynamically (B1, B2, etc.) I will change the sheet names if needed.
Thanks in advance for your help!