Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
replace vlookup
we have a couple hundred sales people in different regions. I am always
doing a vlookup to pull in regions on different reports. can you suggest some code so I can just click a macro and have it tell me the region. i would like it to be as fast as possible, so maybe the lookup data should be in the code rather than in a separate spreadsheet? I would like it to be hard coded instead of a formula when I am done. I was thinking that I would highlight the range of cells that need a region, maybe a pop up box asks me what column has the reps' names and then it populates region in the my range of cells. i tried, but I don't know how to have code replace a vlookup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i replace #n/a in a vlookup? | Excel Worksheet Functions | |||
Replace a vlookup #N/A result with a value | Excel Worksheet Functions | |||
Replace Vlookup with a macro | Excel Discussion (Misc queries) | |||
How do I replace a return value of #N/A in a vlookup with zero? | Excel Worksheet Functions | |||
When VLOOKUP returns a #N/A How can you get it to replace #N/A wi. | Excel Worksheet Functions |