Hi,

Am Tue, 27 Sep 2016 18:38:37 -0700 (PDT) schrieb :

I need the index match to look and pull a value from different spreadsheet, however, if it comes back as error (no match), i want it to pull in value from a different cell (S2) - if S2 is blank again, I want the formula to display a text error "No Rep Assigned". Here is how far I got.

=IFERROR(INDEX('SFDC Data.xlsx'!$A:$A, (MATCH(A2, 'SFDC Data.xlsx'!$E:$E,0))),"")

why do you have the file extension into the formula if you look for data
from another sheet?
Try:
=IFERROR(INDEX('SFDC Data'!$A:$A,MATCH(A2,'SFDC Data'!$E:$E,0)),IF(S2="","No Rep Assigned",S2))


Regards
Claus B.
--
Windows10
Office 2016