Excel help!
 

Guys i'm trying to work on a presentation and need some help!

Refer to below screenshot

Question 1 - In Cell D4, I need to add a trend icon (conditional formatting, icon sets, directional) to show the trend direction of the 3 numbers. How can I do this?

Question 2 - I have table 2 as the raw data, and in table 1, i need to look up the value for "single & march" and drop it into the cell B12 and "triple and March" into B13 etc. for all the remaining cell. How can I do this?

Attachment 30663

Question1:
Question2: vlookup

Not sure if those would work, but that's my guess at it.

Vlookup & match formula

Q2: Vlookup, but I would separate the data table by Month's

Question 1 - any help here?

Question 2 - Vlookup + Match, i will try it out. Vlookup itself will not work as it needs to look up 2 variables.

Will continue to help for thanked posts. :troll:

The video is not what i'm looking for though. Maybe wrong link?

Basically, I want to use the directional arrows to say

1.6 1.5 1.3 - it's trending down and show an arrow.

1.5 1.4 1.6 - staying the same, and show the steady arrow.

hope i'm explaining this ok.

https://support.office.com/en-us/art...9-873614413ce1

Yeah I don't think I understood the question the first time around.

This should be what you're looking for. Though, it's a graph not an arrow.

Alternatively, you could take the difference of the numbers, they're within you're steady parameters you conditional formatting to have a even sign. If it's negative outside your parameters, down arrow. If positive outside your parameters, up arrow.

You could also use numerical differentiation to find the change in slope of the data points. the resulting number would give you a positive number, trending up. Negative number trending down. or approximately zero, steady.

https://en.wikipedia.org/wiki/Numerical_differentiation

OOoh. sparklines may just work. I shall try tomorrow.