|
|
#3
04-07-2020, 01:46 PM
|
|||
|
|||
Not working
I'm not sure if it needs to change to the R1C1 format or what?
I tried "A1" and no luck, Also tried A1:A17 range - still getting error Can you take a look at NEW attachment (saved as xlsm) Not sure how to put it in the R1C1 format Also, I'm trying to get the result to appear in column K currently for the test But will then move it into col B (so the formula in B will adjust based on the length of the filename in col A 
|
| 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 10 
Office 2019
Threaded Mode