Multiple VLOOPUP Values and Criteria

HI Thomas,

Try using below formula:-

Formula:

=INDEX(Signatures!$A$1:$E$52,MATCH(IF(ISTEXT($C21),$C21,$D21),Signatures!$A$1:$A$52,0),MATCH('Customer Entity List'!$B21,Signatures!$A$1:$E$1,0))

see attached:- Signature.xls

Regards,
DILIPandey
<click on below * if this helps>