software

I am trying to reference sales using two factors (Year, and day)

Here is how I received the data

Year Day sales
1985 1 x
l l s
l l x
l l x
2005 30 z

Here is the format I want it inDay 1985 1986 1987 1988 1989
1 b2?
2
3
etc..

Is there any way I can use the 1985 and day 1 to find the right value
in B2 (sales)--
cb3291u
------------------------------------------------------------------------
cb3291u's Profile: www.excelforum.com/member.php...foamp;userid=7822
View this thread: www.excelforum.com/showthread...hreadid=525704Checkout:

www.cpearson.com/excel/lookups.htm

--
Gary's Studentquot;cb3291uquot; wrote:

gt;
gt; I am trying to reference sales using two factors (Year, and day)
gt;
gt; Here is how I received the data
gt;
gt; Year Day sales
gt; 1985 1 x
gt; l l s
gt; l l x
gt; l l x
gt; 2005 30 z
gt;
gt; Here is the format I want it in
gt;
gt;
gt; Day 1985 1986 1987 1988 1989
gt; 1 b2?
gt; 2
gt; 3
gt; etc..
gt;
gt; Is there any way I can use the 1985 and day 1 to find the right value
gt; in B2 (sales)
gt;
gt;
gt; --
gt; cb3291u
gt; ------------------------------------------------------------------------
gt; cb3291u's Profile: www.excelforum.com/member.php...foamp;userid=7822
gt; View this thread: www.excelforum.com/showthread...hreadid=525704
gt;
gt;