Forum Discussion
8932LDG
Feb 13, 2025Copper Contributor
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...
SergeiBaklan
Feb 13, 2025Diamond Contributor
That's duplication of Assistance with complex VLOOKUP formula | Microsoft Community Hub