Pablo Gallardo's Blog
My professional web log about SAP and IT
 

INDEX and MATCH as alternative VLOOKUP in Excel

VLOOKUP is a very useful and powerful Excel formula. It has however, its limitations: for example, the searched word must be obligatory in the first column of the search matrix. This article provides an alternative to VLOOKUP.

The alternative would be to use a combination of the formulas INDEX and MATCH instead. There are plenty of tutorials on the web about this couple of formulae.

Source:

 

pmgallardo

About pmgallardo

I studied Computer Science at University of Salamanca. Since then, I have been working first as developer and then as SAP consutant. This blog is about problems I dealt when using computers, and more important, the solutions I found. Whenever I am on an issue and suddenlly I have a flash that leads me to a solution, I document my discoveries in a post.

No comments yet.

Leave a Reply

Política de privacidad