Formula returned value & displayed value are different

Hi,
I am trying to retrieve dynamically a sub-table, from the sheet "MasterTable", to the sheet "Inspection".
Following this guide: https://www.youtube.com/watch?v=tqCEY5YMyqw&t

But for me, it doesn't preform correctly, and I can't figure what I have done wrong.

The value that the formula returns (the correct value) is different from the value that the cell displays (the correct value).


For example:


This is the formula in cell B33:

Please Login or Register  to view this content.

This is the displayed value (wrong value):
A.PNG

This is the calculated value (correct value):
B.PNG




This is the formula in cell C36:

Please Login or Register  to view this content.

This is the displayed value (wrong value):
C.PNG

This is the calculated value (correct value):
D.PNG


See my worksheet below:

It would be CTRL+SHIFT+ENTER on a Windows machine, but it doesn't seem to make any difference here.

As I said, it makes no difference here. Hopefully it will work for the OP.

As you are using the 2010 version of Excel you can utilize the AGGREGATE function as opposed to using SMALL(IF... and avoid having to use the Ctrl, Shift and Enter activation of the formula.
The formula for cell B33 is:

Formula:

Please Login or Register  to view this content.

Once the formula is entered into cell B33 drag the fill handle over to cell F33 and then, while B33:F33 are still selected, double click the fill handle to copy down to row 118.
Let us know if you have any questions.