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