Hi MF,
1. This answer depends on the type number being unique.
2. When you say separate Worksheet, I am assuming a different worksheet within the same workbook.
If so, then:
Sheet 1 has:
--A----------B-------------C
Type: Description: Price:
Select column A, then click Insert, Name, Define,
In the Names in workbook: box enter: Type
The Refers to: box should contain =Sheet1!$A:$A.
Click Add.
Click Close.
Select column B repeat the above entering Description in the Names in workbook box.
Select column C repeat the above entering Price in the Names in workbook box.
Populate the above table with your type description and price data.
Save the workbook!
Sheet 2 has:
A--------------B---------C-----D-------E----------F--------G--------H
Order no: Date In: Type: Qty: Date Out: Price: Per unit: Total:
Assuming Row 2 is the first row with data, enter this formula in cell F2:
=IF(A2="","", INDEX(Price,MATCH(C2,Type,0),1))
Then copy the formula down.
You do not have a column for the description in your example, but the formula for that column is:
=IF(A2="","", INDEX(Description,MATCH(C2,Type,0),1))
Hope this helps
EG