Set up a table in another range. Perhaps in Sheet2, if your main sheet is
Sheet1. The table (Sheet2!A1:A5) should look like this:

H
WH
O
B
AN

In Sheet1!B1 (next to WH in A1), enter this formula:

=MATCH(A1,Sheet2!$A1:$A5,0)

Fill this formula down as far as needed.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"jfcby" wrote in message
oups.com...
Hello,

On worksheet6 I have 500 rows of data. In columnA it has data like H,
WH, O, B, AN. In columnB I would to add 1, 2, 3, 4, 5. I want

What my worksheet looks like now ColumnB is blank:

ColumnA
WH
O
O
B
AN
H
H
H

The way I would for my sheet to look like:

ColumnA ColumnB
WH 2
O 3
O 3
B 4
AN 5
H 1
H 1
H 1

Thank you for your help in advance,
jfcby