Forum Discussion

Joabrown's avatar
Joabrown
Copper Contributor
Feb 23, 2023

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...
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Feb 23, 2023

Joabrown 

 

Try

 

=IF(AND('CURRENT '!$D21="$B16", 'CURRENT '!Z21="I"), F$2, "")

Joabrown's avatar
Joabrown
Copper Contributor
Feb 23, 2023

HansVogelaar 

 

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?

 

 

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Feb 23, 2023

    Joabrown 

    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?

    • Joabrown's avatar
      Joabrown
      Copper Contributor
      Feb 23, 2023
      https://www.dropbox.com/s/gu2gvm5p6x66dza/contractor%20IF%20Functionality.xlsx?dl=0
      Hiya Let me know if this works, thanks
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Feb 23, 2023

        Joabrown 

        Thank you. I'm afraid I don't understand what you want at all. Perhaps someone else can take a look.

    • Joabrown's avatar
      Joabrown
      Copper Contributor
      Feb 23, 2023

      HansVogelaar 

       

      Sorry for my ignorance, this is the first time I have used the tech community hub and can't see how to attach, can you advise?

      Thanks 

       

Resources