Need Help: formula doesn't recognize Results for another Formula

[siglehart]

I have created a spreadsheet designed to list Missing Numbers and I need help formulating a formula to recognize the results from another formula. I currently have to

manually type in the numbers in the "Enter #'s" Column A5:A20. I want to use the formulas =B1, =Mid(B1,5,1), =Mid(B1,9,1), Right(B1,1), etc. to list the numbers that are in columns B thru G, however the formulas listed below does not recognize the numeric results produced by the formulas in column A5:A20.

Can someone help me solve this problem? Thank you in advance

=IF(ISERROR(VLOOKUP(0,$A$5:$A$21,1,FALSE)),0,"") This formula is in column B row 5

=IF(ISNUMBER(MATCH(ROWS($A$5:$C5),A$5:A$20,0)),"",ROWS($A$5:$C5 )) and this formula is in Column B row 6 to 20

Example of Spreadsheet below

B D F H

#'s	3 - 6 - 4 -8		6 - 3 - 5 -8		8 - 4 - 7 -2		1 - 2 - 8 -3
	Results of missing numbers	09
Enter #'s
3	0
6
4
8
6
3
5
8
8
4	9
7
2
1
2
8
3

<tbody>
</tbody>

 

[AhoyNC]

The functions MID. RIGHT, etc. are going to return a text string and not a numeric value. If you need a numeric value try.
=MID(B1,5,1)+0

 

[siglehart]

The functions MID. RIGHT, etc. are going to return a text string and not a numeric value. If you need a numeric value try.
=MID(B1,5,1)+0

Thank you so much ! It worked perfectly.

 

[AhoyNC]

You're welcome. Thanks for the feedback and welcome to the forum.