|
|
#18
04-22-2020, 05:01 PM
|
||||
|
||||
Always nice to be appreciated, ChrisOK. One thing I don't understand: I suggested (twice) that it might be simpler to use a single formula, using not the MID function but RIGHT and LEFT. You could put that formula in column K, omit the table of formula entirely and not have to write or use any VBA program. Did you have some reason not to want to use that solution, or did you just not see it (twice)?
|
| Tags |
| paste formula lookup |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| LOOKUP Formula error but WHY??? | Haga | Excel | 1 | 04-17-2019 11:13 PM |
| N/A Value in Lookup Formula | NickFazer | Excel | 2 | 04-02-2019 04:22 AM |
| How to update lastname with the help of V-Lookup formula? | Mangesh1212 | Excel | 6 | 12-05-2018 02:15 AM |
| Need help with lookup formula | tristanlau | Excel | 1 | 08-14-2017 07:16 AM |
 Lookup / Paste Multi Values VBA
|
Mav | Excel Programming | 6 | 05-10-2015 08:42 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode