## Using Vlookup

### Using Vlookup

Hi,
I have a couple of questions and would really appreciate help on them.

I am trying to find out from a series of data I have whether or not
the desired goal was acgieved.

For example, the goal being

Difference in percentage should lie within plus or minus 1%

Now , I have a set of values like

0.12%
12%
-0.07%
5%
.
.
.
.

I need to set up a formula in an adjacent column such that it checks
the above values and sees if it lies within plus or minus 1% and
accordingly signals green or red.

How do I go about setting this formula?

### Using Vlookup

I don't quite understand.  plus or minus 1% of what?  the cell above or are
they all being compared with one number?

Conditional formatting will be able to give different colours depending on
value.

Barbara

Quote:> Hi,
> I have a couple of questions and would really appreciate help on them.

> I am trying to find out from a series of data I have whether or not
> the desired goal was acgieved.

> For example, the goal being

> Difference in percentage should lie within plus or minus 1%

> Now , I have a set of values like

> 0.12%
> 12%
> -0.07%
> 5%
> .
> .
> .
> .

> I need to set up a formula in an adjacent column such that it checks
> the above values and sees if it lies within plus or minus 1% and
> accordingly signals green or red.

> How do I go about setting this formula?

### Using Vlookup

I agree with Barbara: it is conditional formatting that you need, not a
lookup - in fact, not any separate cell formula at all.

Select the cells containing the percentages to be evaluated as meeting or
not meeting your 'goal'. Go to "Format", "Conditional Formatting". Apply the
following settings:

"Cell Value Is"
"between"
[your low flag percentage, i.e. -1%]
[your high flag percentage, i.e. 1%]

Click "Format" and choose how you want the cell to look when the condition
is met, i.e. your 'goal is achieved' - green text/fill etc.

Apply the following settings:

"Cell Value Is"
"not between"
[your low flag percentage, i.e. -1%]
[your high flag percentage, i.e. 1%]

Click "Format" and choose how you want the cell to look when the condition
is not met, i.e. your 'goal is not achieved' - red text/fill etc.

Click OK.

Lynne Cartwright

Quote:> Hi,
> I have a couple of questions and would really appreciate help on them.

> I am trying to find out from a series of data I have whether or not
> the desired goal was acgieved.

> For example, the goal being

> Difference in percentage should lie within plus or minus 1%

> Now , I have a set of values like

> 0.12%
> 12%
> -0.07%
> 5%
> .
> .
> .
> .

> I need to set up a formula in an adjacent column such that it checks
> the above values and sees if it lies within plus or minus 1% and
> accordingly signals green or red.

> How do I go about setting this formula?