IFERROR with Index Match need to return numeric empty cell not text empty cell

**olga6542** · 08-29-2020, 10:45 PM

This is the formula that I have: =IFERROR(INDEX(H7:H9,MATCH(A2,G7:G9,0)),"")

"" returns text empty string when selection is not made. I need to return either numeric empty string or blank cells, so the other formulas do not return #value error. See attached.

**wk9128** · 08-29-2020, 11:00 PM

Change your formula
B2 =IFERROR(INDEX($H$7:$H$9,MATCH(A2,$G$7:$G$9,)),)

EXCEL MAIN MENU\EXCEL Options\Advanced\

pls search

display 0 in cells with a value of 0

Pls Remove The tick4.jpg

**olga6542** · 08-29-2020, 11:24 PM

I couldn't find display 0 in cells with a value of 0. What do you mean remove the tick?

**Bo_Ry** · 08-30-2020, 02:07 AM

Please try at C2

=IF(B2="","",B2*6)

IFERROR with Index Match need to return numeric empty cell not text empty cell

LinkBack

Thread Tools

Rate This Thread

Display

IFERROR with Index Match need to return numeric empty cell not text empty cell

Re: IFERROR with Index Match need to return numeric empty cell not text empty cell

Re: IFERROR with Index Match need to return numeric empty cell not text empty cell

Re: IFERROR with Index Match need to return numeric empty cell not text empty cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Can't get a hyperlink to the first empty cell in a column of non-numeric values

[SOLVED] IFERROR and last row and a empty list of text

[SOLVED] Subtracting a 0 from a empty cell and wanting to return a empty cell

[SOLVED] Ignore concatenation in Index Match if cell is empty

[SOLVED] Return text from a cell unless it is empty

error writing to cell if a numeric text box is empty

[SOLVED] display last non empty cell text - VLOOKUP, INDEX, MATCH not working :(

Bookmarks

Bookmarks

Posting Permissions