|
|
#4
04-07-2020, 01:52 PM
|
|||
|
|||
I updated the test file again just now to
"A2" only (for the Len Range) and then changed O2 to NOT have quotes on either side of the formula and it pasted the result of the formula (not the formula) If I put the quotes back, it pastes the formula with quotes and therefore does not function as a formula 
|
| 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