Need to lookup value in cell, dependent on value in another cell

[StaceyJ]

Hello,

I have a Wrapup worksheet in my excel file and an Inventory worksheet.

The inventory worksheet displays every day for the quarter so far, the total
sales, and the total orders.

Example:
Date Day $ Total Sales # Orders
04/01/2007 Sun $12,592.76 31
04/02/2007 Mon $13,450.03 31
04/03/2007 Tue $10,714.48 20
04/04/2007 Wed $14,394.63 25
04/05/2007 Thu $8,730.52 18
04/06/2007 Fri $11,319.69 29
04/07/2007 Sat $8,427.95 18
04/08/2007 Sun $13,831.33 30
04/09/2007 Mon $13,716.92 33

On the wrapup sheet, I want to be able to reference the Total Daily Sales
and the Total Daily Orders, depending on what date is entered into a specfiic
cell on the Wrapup Sheet.

For instance, if on the wrapup sheet I typed 04/09/2007 into cell A:1, in
Cell B:1 I would want it to display the Total sales for that day ($13,716.92)
and in cell C1 the Total Orders (33). If I changed to date to 4/8/2007, the
values in cells B1 and C1 would automatically change to match up with the
values in that line on the Inventory worksheet.

Does this make sense and is this possible?

Thanks!

--Stacey

 

[Toppers]

B1: =VLOOKUP(A1,Inventory!A2100,3,0) will give $ Sales

C1: =VLOOKUP(A1,Inventory!A2100,4,0) will # Orders

Assuming data on Inventory sheet is columns A to D (Date/Day/$ total Sales/#
Orders) starting row 2


HTH