Hi,
New to this so please be patient.

I am extracting data from an ODBC source into a worksheet. The number of
rows will vary according to certain criteria. However one of the columns
will return a numeric value, which I would like to show some text for
according to its value. This list is static and on my 2nd sheet.
i.e.
1st sheet

Columns:
Ref Date No of Units Status Text
Data: Ref1 01/02/2006 23 0 Good
Ref2 01/03/2006 22 2 Bad
Ref2 01/03/2006 22 1 Ugly
etc

2nd sheet

Column:
Status Text
Data: 0 Good
1 Bad
2 Ugly

This works for the 1st row, but if I drag/copy my formula then subsequent
rows don't

Any help would be great,

Regards

D