=IFERROR(INDEX(Temp!$E$2:$E$93,SMALL(IF(A$1=Temp!$B$2:$B$93,ROW(Temp!$E$2:$E$93)-2,""), ROW()-2)),"")
I am trying to add a formula to do vlookup for multiple values. A1 should be source value and if there is matching data in column B I would like to call column E data. Currently its giving me a blank cell. How can I fix this code to make it work?
Aucun commentaire:
Enregistrer un commentaire