mardi 27 novembre 2018

excel if and index formula for calling multiple values

=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