I am using INDEX MATCH as a replacement for VLOOKUP.
I have two INDEX MATCH formulas, side by side, returning values that are also side by side, using the same lookup value and array
Cell E3
cell F3Please Login or Register to view this content.
Is there a way to put a formula in E3 that will also populate F3? Like an Array formula?Please Login or Register to view this content.
Bookmarks