| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA or Vlookup?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Threaded Mode
