vlookup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jhnewyork - 09 May 2008 07:00 GMT

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!

Signature

Thanks,
Jennifer

Reply to this Message

Bob Bridges - 09 May 2008 07:35 GMT

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(RC2>RC1,"x",""). In column 4, =IF(AND(RC1="",RC2<>""),"x",""). And so
on.

So what do you really want?

> 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
[quoted text clipped - 3 lines]
> what I want to do and know it's possible, but can't figure out what the
> formula is - help!

Reply to this Message

jhnewyork - 09 May 2008 08:25 GMT

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.

Signature

Thanks again,
Jennifer

> Tell me whether I've got this right. You have a sheet that looks something
> like this:
[quoted text clipped - 33 lines]
> > what I want to do and know it's possible, but can't figure out what the
> > formula is - help!

Reply to this Message