Lookup 1

[wayneryeven]

Hello All
I have a download into excel that gives me a list of items and the Qty sold on each date:

Item1 60 01/09/2008
Item1 20 02/09/2008
Item2 30 02/09/2008

In another worksheet I want to do a lookup with the Item in rows and the Sold dates in columns:

01/09/2008 02/09/2008
Item1 60 20
Item2 30

What is my best way to achive this? I have been looking into H and V Lookups. Ideally i would like a standard formula in a call which 1) gets the date from the column and 2) gets the Item type by looking across the row. Then taking these two items of info goes to my other worksheet and grabs the info it needs and pulls it back.

I trust this makes SOME sense! Thanks to all,

 

[wayneryeven]

Ok I have fixed this! (Can i give myself a star?? )

Heres what i done:

I defined the columns needed as named ranges. (Qty, Item and Date)

I then applied this formula:
=SUMIFS(Qty, Item, A55, Date, AT3)

This SUMS the Qty against the multiple criteria specified (in this example where Item is equal to the Item name in Cell A55, and Date is equal to the date in Cell AT3).

Trust this makes sense to anyone who may come across this thread.

 

[Gavona]

Makes sense. You might also consider a pivot table to give you the results you wanted.

Gavin

 

[Welshbird]

Wayner - I'll give you a star for that.

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen