Forum Discussion

8932LDG's avatar
8932LDG
Copper Contributor
Feb 13, 2025

Optimizing Excel Formula for Dynamic VLookup

Hi, I have this formula: =IF(F2="", "", VLOOKUP(IF(VLOOKUP(F2, $A$2:$I$1400, 4, FALSE) = 0, VLOOKUP(F2, $A$2:$I$1400, 6, FALSE), F2), $A$2:$I$1400, 9, FALSE)) This formula is meant to fill in the Ma...

Resources