Excel question please help.?
I have a cell b14 which is a variable and cell b15 gives the answer from the formula =b14-d6. But d6 is part of a range d6:d12. This range represents values input over 7 day period! How do I adjust the formula in cell b15 that will only look at the todays value within the d column?? Thanks
More Questions From This User See All
Answers & Comments
Verified answer
How you do it depends on how you know which of the values in D6:D12 is today's value.
For example, if the corresponding dates are in A6:A12, then it's pretty straightforward. You could use VLOOKUP:
=B14 - VLOOKUP(TODAY(), A6:D12, 4, FALSE)
This finds today's input value by looking for Today's date in column A, and then when it finds it, goes to the 4th column in the range (D) on that same row.
I'm assuming it's not that simple though, so again, how do you know which value is today's input?
Please edit your answer to add more details.
Cheers.
.
copy your column with the range and paste special the values- use that column for your d6 rather then the actual range- it puts another column in- but it helps to get your value you need at that point. hope i explained this right- if not microsoft have awsome tutorials online.