looking for way to PASTE a formula from a lookup table using either a function -- or using VBA --- (if it can be done both ways, would love to see how it's done for versatility) THANK YOU - (small example attached)

In a nutshell, IF the length of column A file name is 21 chars long, then PASTE SPECIAL FORMULAS the formula found in Cell O$2$


IF the length is is 22 then use the formula in $O$3
(potentially, this lookup table could have more scenarios but for now, just 2)

IF LEN IS 21 THEN USE THIS FORMULA,
IF FORMULA IS 22 USE OTHER FORMULA

Attached Files

test-paste-formula.xlsx (15.5 KB, 8 views)