Afternoon all,

Could someone help with the following? Sorry it's a bit long!

In sheet1 'A1' I want to enter the 'Prod Code' and in A2 the 'type'
In sheet2 there is an array of data
A B C D
Prod Code Item Type Price
1234 Ham loose 1.39
1234 Ham prepacked 1.59
5678 Cheese Brie 1.99
5678 Cheese Stilton 3.29
[There are another 20000 rows like this not in order]

When the 'Prod Code' is entered on sheet1 A1, and 'type' in A2 I want it to
find the exact 'Prod Code' and 'type' and paste 'Prod Code' 'Item' 'Type'
'Price' in sheet1 B1

If anyone could help, it will save me a week's worth of copy and paste-ing!!

Thanks

Simon.