I
instereo911 via OfficeKB.com
Good afternoon, I tried most of all that was posted on double VLOOKUP but had
no sucess.
My Chart Looks Like this:
Sheet 1,
A B C D
1 01/01/2007 AM 67 84
2 01/01/2007 CU 283 51
3 01/01/2007 EF 85 412
4 01/01/2007 EU 66 985
5 01/02/2007 AM 61 81
6 01/02/2007 CU 280 61
Etc - all the way up to 02/28/2007
I am looking for sheet2 to look like this and grab the data
A B c D E
F
1 01/01/2007 01/01/2007 01/02/2007 01/02/2007
2 AM 67 84 61
81
3 CU 283 51 280
61
4 EF 85 412 --
--
5 EU 66 985 --
--
So I want to say something like this on sheet 2 (because sheet 1 has all the
data stored) in cell C2 ... =vlookup(B2&C1,SHEET1!A16,3,FALSE)
And it is not working... Any ideas?
Thanks everyone
no sucess.
My Chart Looks Like this:
Sheet 1,
A B C D
1 01/01/2007 AM 67 84
2 01/01/2007 CU 283 51
3 01/01/2007 EF 85 412
4 01/01/2007 EU 66 985
5 01/02/2007 AM 61 81
6 01/02/2007 CU 280 61
Etc - all the way up to 02/28/2007
I am looking for sheet2 to look like this and grab the data
A B c D E
F
1 01/01/2007 01/01/2007 01/02/2007 01/02/2007
2 AM 67 84 61
81
3 CU 283 51 280
61
4 EF 85 412 --
--
5 EU 66 985 --
--
So I want to say something like this on sheet 2 (because sheet 1 has all the
data stored) in cell C2 ... =vlookup(B2&C1,SHEET1!A16,3,FALSE)
And it is not working... Any ideas?
Thanks everyone