Friday, 20 January 2023

Reverse VLOOKUP in Excel

As we all know there is no way to look up to left for a value using VLOOKUP. But if you switch to INDEX MATCH you can look up in any direction.

 index match sample formula enter

No comments:

Post a Comment