Thread: vlookup
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default vlookup

Do 4 vlokkups to return a different column for each lookup.

"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!
--
Thanks,
Jennifer
--
Thanks,
Jennifer