Forum Discussion
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 ...
What is the formula you're currently using?
Do you need the formula in the same row of Spreadsheet 2 as the row with the date on Spreadsheet 1?
Or do we need to find the correct row? If so, how?
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", "")
- You're a star, you even correct my spelling mistake 🙂