|I have 4 columns in excel that that I am trying to match. I'm trying to get feb data and march data on the same lines so I can determine growth or decline for each individual item.|
Currently the data looks like this:
BIKE $80 CAR $400
SHOW $10 BIKE $88
CAR $440 SHOW $6
I would like to match up all data to show like this:
BIKE $80 BIKE $88
SHOW $10 SHOW $6
CAR $440 CAR $400
There are new items coming on the list and dropping off the list all the time automatically when I run the original report, so when I download to excel it different every month. This being said if a new items comes on that is not in the previous month I would just like to see a blank or n/a, doesn't really matter.
I've tried VLOOKUP many times and can't get it to work.
Thanks in advance for the help.