LinkBack URL
About LinkBacks
I need to make an IF statement that when it's true it need to retrieve the values from a different column. With what function is it possible to just retrieves values?
Thanks!
Edit:
I need to return the value from pivot table. Forgot to mention this.
I need to make an IF statement that when it's true it need to retrieve the values from a different column. With what function is it possible to just retrieves values?
Thanks!
Edit:
I need to return the value from pivot table. Forgot to mention this.
Last edited by Jonathan9; 09-26-2013 at 11:18 AM.
Formula:
Please Login or Register to view this content.
where <condition> is an expression that you want to determine if it's true, B1 is a reference to a value in a different column (or anywhere at all), and <false result> is what you want to happen if the condition is false.
This is a fundamental feature of Excel. You can find more in the Excel Help page for the IF function.
Thanks! Got it work, almost, was just thinking in the wrong way
Just one more thing. I'm returning the value from a pivot table that is filtered so there are a lot of hidden rows which means that it will only return a value if the rows correspond is there a way to make it return values sequentially rather than chronologically?
After some research I think I need to use the Offset function - but I can't get that to work as I, presumably, need to specify all the rows which is not very desirable because it's about 7000 rows. Anybody that know how to return values from a filtered pivot table?
Please start a new thread with this new question. Chances are you won't get an answer easily if you leave it in this thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks