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!A1:D6,3,FALSE)

And it is not working... Any ideas?

Thanks everyone

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200705/1