Formula is correct but returns A Value Is Not Available to the Formula or Function.

**Lcook** · 02-07-2017, 04:57 PM

I am just now learning how to use the Index, Match formula. First it was the number, text thing with an error of #Value. Now I keep receiving #N/A and I don't have any blank cells. What am I missing?

**JieJenn** · 02-07-2017, 04:59 PM

Put IFERROR function around it.

**Lcook** · 02-07-2017, 05:02 PM

I am sorry but what do you mean "around it?"

Formula is correct but returns A Value Is Not Available to the Formula or Function.

LinkBack

Thread Tools

Rate This Thread

Display

Formula is correct but returns A Value Is Not Available to the Formula or Function.

Re: Formula is correct but returns A Value Is Not Available to the Formula or Function.

Re: Formula is correct but returns A Value Is Not Available to the Formula or Function.

Thread Information

Users Browsing this Thread

Similar Threads

Attempting to construction a function or formula where the formula returns the row value o

[SOLVED] SUMIF Formula not working - returns zero which is not correct

IF= Function Arguments are correct yet Workbook returns #VALUE!

Index formula with multiple values only returns correct values on first item

Excel 2007 : MAX Returns 0 in Cell but Correct # in Function Argument Box

Formula returns 0 value shows #NAME? error in 2003, correct value in 2007

Formula is correct but returns #N/A

Bookmarks

Bookmarks

Posting Permissions