LOOKUP formula change

Hi all, I am working to utalize LOOKUP formula below and was wondering if anyone would know how would I be able to change the below formula to do below 2 actions. Any help would be very much appreciated. Thanks so much!

1) whatever the result is to add +1. So if it finds 3, then it would be 4

2) if there is no match to leave the cell blank. currently it generates a 0. I tried to change 0 in below formula to """"" but would not work for some reason...

Please Login or Register  to view this content.

Hi,
Try

Please Login or Register  to view this content.

You could simplify the formula considerably by adding a key column to the 'previous day' sheet that concatenated the three criteria columns into one.

No - remove the ) before the + 1 - typo on my part.

This may be flexible but concatenation will be much more efficient.