vertical lookup one is giving #n/b outcome

[Mortethuis]

Dear Sir, Madame,

I am would like to give each restaurant and shift number.

For some reason one of the restaurants is not being recognized and is giving me a #n/b outcome.
To make sure all value/formatting of the restaurants is correct I made a pivot table based on restaurants and copied special; value and number notation.

Please see attached the excel sheet (Please note that I had to change it to xml. vs ods extension) with the one restaurant which give the wrong outcome.


Thanks in advance.

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.