I've got a set of data in Excel that I want to fill in with data from another tab via VLOOKUP. Easy I hear you say, but I want to use two different values to VLOOKUP from.
For example,
I want to filter on a product, for arguments sake let's call it 'MOBO' and how many we sold on a particular date.
So my raw data will look something like the below
As you can see the data fluctuates on a day to day basis. Now, I want to reflect this data on another tab via a LOOKUP query.
How do I do this? The data on the other tab is also split by dates. So therefore I need to use a VLOOKUP query using the date and 'MOBO'?
Thanks for any help.
For example,
I want to filter on a product, for arguments sake let's call it 'MOBO' and how many we sold on a particular date.
So my raw data will look something like the below
Code:
COLUMN1 COLUMN2 COLUMN3 COLUMN4 Total
MOBO 01-Aug-06 430 466 40 1 937
MOBO 02-Aug-06 430 466 40 1 937
MOBO 03-Aug-06 430 466 40 1 937
MOBO 04-Aug-06 430 466 40 1 937
MOBO 05-Aug-06 430 466 40 1 937
MOBO 06-Aug-06 430 466 40 1 937
MOBO 07-Aug-06 428 455 40 1 924
MOBO 08-Aug-06 427 454 40 1 922
MOBO 09-Aug-06 425 453 40 1 919
MOBO 10-Aug-06 425 453 40 1 919
MOBO 11-Aug-06 425 452 40 1 918
MOBO 12-Aug-06 425 452 40 1 918
MOBO 13-Aug-06 425 452 40 1 918
MOBO 14-Aug-06 420 402 40 1 863
MOBO 15-Aug-06 420 402 40 1 863
MOBO 16-Aug-06 419 399 40 1 859
MOBO 17-Aug-06 419 399 40 1 859
MOBO 18-Aug-06 419 398 40 1 858
MOBO 19-Aug-06 418 398 40 1 857
MOBO 20-Aug-06 418 398 40 1 857
MOBO 21-Aug-06 414 364 40 1 819
MOBO 22-Aug-06 413 364 40 1 818
MOBO 23-Aug-06 413 364 40 1 818
MOBO 24-Aug-06 413 364 40 1 818
MOBO 25-Aug-06 412 364 40 1 817
MOBO 26-Aug-06 411 364 40 1 816
MOBO 27-Aug-06 411 364 40 1 816
MOBO 28-Aug-06 407 341 40 1 789
MOBO 29-Aug-06 407 341 40 1 789
MOBO 30-Aug-06 407 341 40 1 789
MOBO 31-Aug-06 406 341 40 1 788As you can see the data fluctuates on a day to day basis. Now, I want to reflect this data on another tab via a LOOKUP query.
How do I do this? The data on the other tab is also split by dates. So therefore I need to use a VLOOKUP query using the date and 'MOBO'?
Thanks for any help.