MATCH | SMALL | IF Formula Error Help Needed

**chad328** · 01-06-2016, 07:15 AM

Hi everyone,

I am using a combination of:
=MATCH
=SMALL
=IF

Formulas on the same sheet,
they are linked to cells also on the same sheet,
Some of the cells are not always full of content & this I believe brings up the #NUM Error.

I would like to remove this error or alter the code/formula in such a way it will not be seen.
Any help with the above would be much appreciated & I thank you in advance.

I have attached an example file with the error section coloured Blue

Please Login or Register  to view this content.

Thanks in advance again,
Chad

**kvsrinivasamurthy** · 01-06-2016, 07:25 AM

Try this
=IF(ISERROR(Your Formula),"",Your Formula)

**shukla.ankur281190** · 01-06-2016, 07:30 AM

As you used Iferror function in AK column, use the same with your all formula for avoiding the error value.

See the post. https://exceljet.net/excel-functions...error-function

**chad328** · 01-06-2016, 07:41 AM

Thank you for the reply's guys,
I have implemented what has been suggested but still get the same error's in AS14 | AT14 | AU14

Thanks
Chad

**shukla.ankur281190** · 01-06-2016, 07:51 AM

try
AN14=IFERROR(MATCH(AO14,WinOdds,0),0)
AO14=IFERROR(SMALL(WinOdds,ROW(AN3)),0)
AP14=IFERROR(IF(AO14<>"",1/AO14,0),0)
AR14=IF(AQ14="D",AP14,"")
AS14=IF(AO14<>"",IF(AQ14="D",AP14/AR36,""),"")
AT14=IF(AR14<>"",AS14*AO11,"")
AU14=IF(AO14<>"",IF(AT14<>"",(AO14*AT14)-AT36,-AT36),"")

**chad328** · 01-06-2016, 08:04 AM

Thank you guys so very very much,
I have dwelled on this for hours.

shukla.ankur281190 you had the right solutions mate,
I thank you for doing what you do brother!

Many thanks,
Chad

**shukla.ankur281190** · 01-06-2016, 08:12 AM

Glad to help you

if you liked my solution please add reputation by clicking star * icon left corner on your screen.

**chad328** · 01-06-2016, 08:14 AM

Already done brother!
Thanks again, Have an amazing 2016

**shukla.ankur281190** · 01-06-2016, 08:15 AM

Thanks for feedback please mark it as solved

MATCH | SMALL | IF Formula Error Help Needed

LinkBack

Thread Tools

Rate This Thread

Display

MATCH | SMALL | IF Formula Error Help Needed

Re: MATCH | SMALL | IF Formula Error Help Needed

Re: MATCH | SMALL | IF Formula Error Help Needed

Re: MATCH | SMALL | IF Formula Error Help Needed

Re: MATCH | SMALL | IF Formula Error Help Needed

Re: MATCH | SMALL | IF Formula Error Help Needed

Re: MATCH | SMALL | IF Formula Error Help Needed

Re: MATCH | SMALL | IF Formula Error Help Needed

Re: MATCH | SMALL | IF Formula Error Help Needed

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Help Requested with Nested Small Function Inside Index/Match Formula

Formula needed for partial string match as part of index match with multiple criteria

[SOLVED] match/lookup formula for multiple small tables

Excel Formula: IFERROR, INDEX, SMALL, MATCH

Small formula change needed

Large, Small, Index, Match formula combos

INDEX SMALL ROW Formula #REF! error.

Bookmarks

Bookmarks

Posting Permissions