rsides Posted February 5, 2016 Posted February 5, 2016 I want to transfer a cells information from one page to another without using a Vlookup and using the = formula ie ='SIMS Sheet A3' but don't want the blank cells to show as 0. Is there away?
clareq Posted February 5, 2016 Posted February 5, 2016 Possibly an if statement, looking at if SIMS Sheet A3 is blank then " " else A3. Not got the exact syntax in my head at the moment, but that's the logic I'd use.
Seb1780 Posted February 5, 2016 Posted February 5, 2016 Possibly an if statement, looking at if SIMS Sheet A3 is blank then " " else A3. Not got the exact syntax in my head at the moment, but that's the logic I'd use. =if(reference cell="","",reference cell) Should do it. 1
rsides Posted February 5, 2016 Author Posted February 5, 2016 Thank you both. You've saved my sanity. Its been driving mad as I knew there was a way to do it just couldn't make the correct connection to the right formula
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now