Sunday, March 1, 2015

MS Excel - Using Index Match instead of Vlookup



=INDEX ( Column I want a return value from , MATCH ( My Lookup Value , Column I want to Lookup against , Enter “0” ))

 Example,

=IFERROR(INDEX(Sheet5!I:I,MATCH('duplicated clean'!A3,Sheet5!A:A,0)),"")

Reference:

http://www.randomwok.com/excel/how-to-use-index-match/

http://fiveminutelessons.com/learn-microsoft-excel/how-use-index-match-instead-vlookup

No comments:

Post a Comment