Hello guys, this is so difficult for me. I want to combine the “if function” and “=” and it didn’t work for me. See example below. Okay on the 2nd image, I used “If” and if the cell contains “2nd Shift”, the selected cell(with formula) will get the ID number which is”26130328″, but it only gave me the word “=Sheet1!A2”. Do you have any idea or any alternate function? I really need this :).
By: Rilley Synder