dear bob,
it works !! thx very much!

but i get new problem with it. what if i don't have space for formula
you've gave? how to combine those formula into one? like when i use
index in this situation:

SHEET1 (DATA)
A B C

1 CODE CLASS PRICE
2 JOGCGK V 100
3 JOGDPS Z 225
4 JOGSUB S 357


SHEET2
A B C
1 CODE CLASS PRICE
2
3