If command condition with combination of “=” sign

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

Leave a Reply

Your email address will not be published. Required fields are marked *