Forum Discussion

fiscal775's avatar
fiscal775
Copper Contributor
Dec 04, 2023
Solved

Creating different values based on 2 columns in linked spreadsheet

Hello   I have 2 spreadsheets and I need help creating formula as below.  I can do the first step but struggling on the second.   Breakdown If there is a date in column P of Spreadsheet 1 then ...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Dec 04, 2023

    fiscal775 

    Use

     

    =IF('filelocation.xlsx]Mar - May 2024'!P2<>"", IF('filelocation.xlsx]Mar - May 2024'!Q2<>"", "Advice Implemented", "Advice Pending"), "")

     
     
fiscal775's avatar
fiscal775
Copper Contributor
Dec 04, 2023

HansVogelaar 

 

Hello Hans

 

Yes it will be the same numbered row in both spreadsheet.

 

That only updates if there's data in one column but not sure how to add to second part.

=IF('filelocation.xlsx]Mar - May 2024'!P2<>"", "Advise Pending", "")

HansVogelaar's avatar
HansVogelaar
MVP
Dec 04, 2023

fiscal775 

Use

 

=IF('filelocation.xlsx]Mar - May 2024'!P2<>"", IF('filelocation.xlsx]Mar - May 2024'!Q2<>"", "Advice Implemented", "Advice Pending"), "")

 
 
  • fiscal775's avatar
    fiscal775
    Copper Contributor
    Dec 04, 2023
    You're a star, you even correct my spelling mistake 🙂