RE: vlookup by jhnewyork
jhnewyork
Fri May 09 02:25:01 CDT 2008
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(RC2>RC1,"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!