View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] nijazs@gmail.com is offline
external usenet poster
 
Posts: 1
Default Index Match with if or iferror help

Hello, need some help with the formula below.

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))),"")