INDEX/MATCH issues

[cparks]

Having an issue with using some of my "index/match" formulas. When I use my named ranges or when i select a larger range (column) than what that particular column visibly shows, I either get "0" or nothing at all...aside from using either IFERROR, ISBLANK, etc.

I know (or at least Im fairly certain) that when using lookup type formulas each array/criteria range needs to be the same amount of cells.
What gets me is when I select JUST the populated cells (i.e. visible), then the index/match formula works.

What am I missing?

Attached file enclosed.
RED TABS are the target sheets
RED BORDERED COLUMNS are the target columns
GREY SHADED AREAS is how far down formulas go/do not not exceed

Trouble Column with INDEX/MATCH formula: EVALS, Column B

 

[NARAYANK991]

Hi ,

The problem is that you have not used 0 for the third parameter to the MATCH function ; this is absolutely required.

=IFERROR(INDEX(MAIN_DATA_ENTRY_JOB_TITLE,MATCH(MAIN_DATA_ENTRY!A2,MAIN_DATA_ENTRY_EMPLOYEE,0)),"")

Narayan

 

[cparks]

Well...I kinda feel like a fool. I've never had any issues with it before not using the "optional" parameter and have used that formula many times...until now.

Thanks!