Forum Discussion
IF Functions between worksheets
Hi I am using 2 worksheets with contractor names on both. I have tried to create an If Function asking, if the names are the same (in both sheets) AND there is an "i" shown (through conditionally f...
Thank you very much for responding. Unfortunately I still don't get a positive result. By using the formula suggested the result returns as blank when it should return with 52 (the relevant wk number).
There seems to be a problem matching the name cells in both worksheets (first part of formula)
Do you have any other suggestions?
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- https://www.dropbox.com/s/gu2gvm5p6x66dza/contractor%20IF%20Functionality.xlsx?dl=0
Hiya Let me know if this works, thanks
