Hi DeanO and xPete,

many thanks for your prompt answer. however, this is still not working as I
wanted. These categories may appear sevral times in column (A1:A2000). So
the argument will be. in each cell of B1:B2000 I want to see the reference
number specified to its category. Does this formula works? =Vlookup ("IT
Equip","SHE Equip", "Comms Equip", A:B,2,False)

Please advise
Hoshyar

"DeanO" wrote:

I would use VLOOKUP every time!

e.g =Vlookup("IT Equip", A:B, 2, False)

would return 500

Any good? You can of cause change "It Equip" in above to any cell!


"Hoshyar" wrote:

Hi all,

If I have seven categories in Column A and I want to return a reference
number for each category in colum B. is there a VBA module to achieve this or
it is better with Vloop up?

The table looks like this.

Column A Column B
_________ ____________
Office Equip 100
Ops Equip 200
SHE Equip 300
Security Equip 400
It Equip 500
Comms Equip 600
Vehicels Equip 700


any help on this is appreciated

Best regards
hoshyar