Sheet2 houses the reference table in cols A & B as indicated, assumed from
row1
In Sheet1,
Put in F8:
=IF(ISNA(MATCH(D6,Sheet2!A:A,0)),"",VLOOKUP(TRIM(D 6),Sheet2!A:B,2,0))
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"paulh" wrote in message
...
sheet 1
type in to sheet1 d6 (15gr) refer to sheet2 and result in f8 sheet1 to be
3.5
or type in 10gr into d6 sheet 1 and result in f8 sheet 1 to be 2.7
Sheet2
A B
10GR 2.7
15GR 3.5
20GR 5.6