Assume the reference table that you posted
is in Sheet2, in cols A to C
where Codes are in A2 down, Prices in C2 down

In Sheet1,
Assume you have the codes to be looked up, eg: DCX in A2 down
In B2: =VLOOKUP(A2,Sheet2!A:C,3,0)
will retrieve the required price, ie 400. Copy B2 down as far as required.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
"Putu Niki" wrote:
Code Product PRICE
FLX 100
CX 200
DX 300
DCX 400

How get the price value using VLOOKUP or HLOOKUP ?