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

G

Guest

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
 
G

Guest

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

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

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


HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top