Provide an example of before and after. HTH Otto

"JJ" wrote in message
...
I have column A ranging from (Seq)1 - 30 with numerica value. Column B
with
(Description)Text names. The data is to be linked so that whenever the seq
changes, it updates the cells in the worksheet containing th formula.
A1 B1
1 A
3 B
2 C

I have tried the SMALL function but don't know how to link the two
comlumns.