Posted to microsoft.public.excel.worksheet.functions

Ellen G.

Posts: n/a

IF ARRAY LOOKUP ??? Help Please

I need to determine the price of a specific part during a specific period -
help please! The part# and the invoice date drives the price.

RECEIPTS
Invoice
Part# Date QTY
AA 12/01/05 2
AA 11/15/05 12
BB 02/01/06 6
CC 11/15/05 3

PRICING

Part No. Price price chng date
AA .15 10/01/05
AA .18 10/28/05
AA .22 12/22/05
AA .31 02/05/06
BB .16 10/20/05
BB .28 12/18/05
BB .78 01/22/06
CC .38 07/12/05
CC .91 11/16/05

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Array formula lookup	CJ-22	Excel Worksheet Functions	6	February 8th 06 05:45 PM
Lookup array?	HBj	Excel Worksheet Functions	2	January 4th 06 02:47 PM
Weighted avg of numbers not in contiguous row-ie array w lookup?	Diane	Excel Worksheet Functions	2	November 9th 05 02:12 AM
How do I lookup a value in a array that is not in ascending order	John	Excel Worksheet Functions	6	June 20th 05 09:40 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM

All times are GMT +1. The time now is 07:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us