How to calculate a min price out of a long list

[Ahmed Fawad]

hi,

I got 4 rows
1. Product ID: 123456 (6 digit code)
2. Unite Pice
3. Order Ref. #
4. Order date

I need is to have if i enter Product ID in a cell it shows min price, order ref. and date in same row.

Please help

Ahmed

 

[Ahmed Fawad]

OK, here is an example

Excel Workbook
	B	C	D	E	F
5	1	6	*	3	0.5
6	1	4	*	*	*
7	1	4	*	*	*
8	1	4	*	*	*
9	1	2	*	*	*
10	2	1	*	*	*
11	2	7	*	*	*
12	2	8	*	*	*
13	2	5	*	*	*
14	3	1	*	*	*
15	3	0.5	*	*	*
16	3	2	*	*	*
17	3	7	*	*	*
18	4	4	*	*	*
19	5	4	*	*	*
20	5	2	*	*	*
21	5	3	*	*	*
22	5	4	*	*	*
Sheet2

Bundle of thanx bud....

Ok i sorted out my mistake it works now ....

in 2nd part .... we need

order ref. and date ... as per the price searched by formula

Ahmed