Index/Match Error

Sherry Fox

Okay, I am confused by why I am getting this error on my Index/Match formula, so thanks in advance for your assistance. First my error is "Invalid Column Value". I have never seen that error previously, so I am stumped how to proceed. I am doing an Index/Match formula, and I have done multiples of this function, so I am familiar with the format. My formula is on the sheet named QMS Program Metrics (1st screenshot below). And my formula accesses another sheet, Fiscal Quarter Calendar (2nd screenshot below). My formula is:

=INDEX({Days Out}, MATCH(FYQTR@row, {FY QTR}, 0))

=Chris Palmer

Hi @Sherry Fox,

I believe the column properties should be a "DATE" where the #INVALID COLUMN VALUE is.

Sherry Fox

@Mr. Chris ,

That was it! I had it on Text/Number as I was creating a formula in that column. I was not thinking about the type of result that was going to be in that column. Thanks so very much!!!!

=Chris Palmer

@Sherry Fox,

I'm glad this worked for you!