Single INDEX MATCH formula for two cells

[onbeillp111]

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

Please Login or Register  to view this content.

cell F3

Please 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?

[sktneer]

You can have one formula which can be placed in E3 and copied across to F3.
Try this...

In E3

Please Login or Register  to view this content.

And then copy across to F3.