=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