Hi,
I need help to display data from one sheet if blank (or other value if that helps) and data from another sheet if the cell has been filled.
I hope it make sense : )
Thank you.
Kind regards
Krillephar
Hi,
I need help to display data from one sheet if blank (or other value if that helps) and data from another sheet if the cell has been filled.
I hope it make sense : )
Thank you.
Kind regards
Krillephar
"...display data from one sheet if blank...and data from another sheet if the cell has been filled."
in A1
=IF(B1="",Sheet1!C1,Sheet2!D1)
Displays data from one sheet (Sheet1!C1) if blank (B1 is blank), and data from another sheet (Sheet2!D1) if the cell has been filled (B1 is not blank).
adjust the formula to match your requirements.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks