I have revenue numbers for 2007 and 2008 in columns, I need to do a vlookup
(i think) that will classify into four columns demarking wih a check mark
whether column 1 - the revenue increased, column 2 - revenue was new for
2008, column 3 - decreased and column 4 -if it decreased whetheth the
business went away or sales were lower in 2008. I'm fustrated because I know
what I want to do and know it's possible, but can't figure out what the
formula is - help!
--
Thanks,
Jennifer

Tell me whether I've got this right. You have a sheet that looks something
like this:

1 2
1 2007 2008
2 $27 432 $27 097
3 $18 519 $33 400
4 - $10 932
5 $11 392 $10 446
6 $15 506 -
7 $58 585 $46 187

Now you want check marks out to the right showing how things changed:

1 2 3 4 5 6
1 2007 2008 More New Less Gone
2 $27 432 $27 097 x
3 $18 519 $33 400 x
4 - $10 932 x x
5 $11 392 $10 446 x
6 $15 506 - x x
7 $58 585 $46 187 x

Is that about right? I'm thinking not, because this doesn't call for
VLOOKUPs; you just want an IF in each column. In column 3 you want
=IF(RC2RC1,"x",""). In column 4, =IF(AND(RC1="",RC2<""),"x",""). And so
on.

So what do you really want?

--- "jhnewyork" wrote:
I have revenue numbers for 2007 and 2008 in columns, I need to do a vlookup
(i think) that will classify into four columns demarking wih a check mark
whether column 1 - the revenue increased, column 2 - revenue was new for
2008, column 3 - decreased and column 4 -if it decreased whetheth the
business went away or sales were lower in 2008. I'm fustrated because I know
what I want to do and know it's possible, but can't figure out what the
formula is - help!

That will work.

What if I wanted so show the variances in those columns, in your example in
the more column $14,881 instead of an 'x'.
I was thinking there was a vlookup that could calculate variance, put an x
in the more and the actual variance in another set of adjacent 4 columns with
the same titles.

--
Thanks again,
Jennifer


"Bob Bridges" wrote:

Tell me whether I've got this right. You have a sheet that looks something
like this:

1 2
1 2007 2008
2 $27 432 $27 097
3 $18 519 $33 400
4 - $10 932
5 $11 392 $10 446
6 $15 506 -
7 $58 585 $46 187

Now you want check marks out to the right showing how things changed:

1 2 3 4 5 6
1 2007 2008 More New Less Gone
2 $27 432 $27 097 x
3 $18 519 $33 400 x
4 - $10 932 x x
5 $11 392 $10 446 x
6 $15 506 - x x
7 $58 585 $46 187 x

Is that about right? I'm thinking not, because this doesn't call for
VLOOKUPs; you just want an IF in each column. In column 3 you want
=IF(RC2RC1,"x",""). In column 4, =IF(AND(RC1="",RC2<""),"x",""). And so
on.

So what do you really want?

--- "jhnewyork" wrote:
I have revenue numbers for 2007 and 2008 in columns, I need to do a vlookup
(i think) that will classify into four columns demarking wih a check mark
whether column 1 - the revenue increased, column 2 - revenue was new for
2008, column 3 - decreased and column 4 -if it decreased whetheth the
business went away or sales were lower in 2008. I'm fustrated because I know
what I want to do and know it's possible, but can't figure out what the
formula is - help!