Is it possible to write a formula to look up data in a set of columns and based on certain criteria transfer the information to another column.
Screenshots below provide detail about what i am trying to accomplish
Columns B, E, and G have dates and Columns C, D, F, and H have data that i have input
I would like to transfer data to Column K, L, and M if the dates from Column J match the dates in Column B, E, or G and the headings from row with labels (circled in red) match.
Thank you very much in advance for your help.
Screenshots below provide detail about what i am trying to accomplish
Columns B, E, and G have dates and Columns C, D, F, and H have data that i have input
I would like to transfer data to Column K, L, and M if the dates from Column J match the dates in Column B, E, or G and the headings from row with labels (circled in red) match.
Thank you very much in advance for your help.