Need help (formula returns no result)

mahalek1976

New Member
Joined
Dec 29, 2015
Messages
6
{=ifiserror(INDEX('Usable Data'!$B$2:$M$201,SMALL(IF('UsableData'!$M$2:$M$201='Working Staff'!$D$1,ROW('UsableData'!$M$2:$M$201)-1),ROW(A1)),3),"")}

This formula is returning no result

 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
It should be IFERROR, not IFISERROR - does that make a difference?

If not, remove the error trap and tell us what it then returns.
 
Upvote 0
Then do what I suggested: remove the error trap and tell us what you get - what error message?
 
Upvote 0
#VALUE!
<colgroup><col width="498" style="width: 374pt; mso-width-source: userset; mso-width-alt: 18212;"> <tbody> </tbody>
 
Upvote 0
Cross-posted: HElp WIth This formula

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.
 
Upvote 0
The reason why your formula is returning nothing is because the formula contains an error.

=IFERROR(formula,"") will return nothing if the formula results in an error.
=IFERROR(formula,"popcorn") will return popcorn if the formula results in an error.

You have to find out why INDEX('Usable Data'!$B$2:$M$201,SMALL(IF('UsableData'!$M$2:$M$201='Working Staff'!$D$1,ROW('UsableData'!$M$2:$M$201)-1),ROW(A1)),3) is giving you an error. This should be an array formula. Without looking too much into it, try =INDEX('Usable Data'!$B$2:$M$201,SMALL(IF('UsableData'!$M$2:$M$201='Working Staff'!$D$1,ROW('UsableData'!$M$2:$M$201)-1),ROW(A1)),3) Ctrl Shift Enter instead of just Enter.
 
Upvote 0
Thanks for your help so far. The column M that I am looking in for the letter W is actually returning W from a formula. Does this matter?
 
Upvote 0
{=ifiserror(INDEX('Usable Data'!$B$2:$M$201,SMALL(IF('UsableData'!$M$2:$M$201='Working Staff'!$D$1,ROW('UsableData'!$M$2:$M$201)-1),ROW(A1)),3),"")}

This formula is returning no result

1. Check the sheet names: it seems is missing a space in UsableData or there is a wrong space in 'Usable Data"
2 . The formula shoud be (assuming 'Usable Data' is correct)
=IFERROR(INDEX('Usable Data'!$B$2:$M$201,SMALL(IF('Usable Data'!$M$2:$M$201='Working Staff'!$D$1,ROW('Usable Data'!$M$2:$M$201)-ROW('Usable Data'!$M$2)+1,ROWS(A$1:A1)),3),"")

M.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,558
Messages
6,114,296
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top