I Think I Need An IF Statement, Need Help Copying Cell Data

[buddha]

I hope I can explain this well enough. I have this sheet I am working on for something to do at work, and something that doesn't necessarily happen often, but something that needs to be planned for, I am struggling with.

On the Receipts sheet, in column d, the 'seal #' column, I need to pull data from multiple sheets if it exists, and if more than one is pulled, it needs separated by a slash, and if nothing, left blank.

In my mind, I feel it would be done with an IF statement, but not quite sure how to write it out. Basically, it will pull data from the Run x RoF sheets, corresponding to the denominations. Just for sake of ease, assume we are talking about the first one, NRT 1, 1's, which on the Receipt sheet will be cell D2. It will pull data from Run 1 RoF C4 if applicable, and if not, then Run 2 RoF C4, then RoF3, the RoF4. If there are none it will stay blank, but if the machine was accessed, the seal number needs to be copied. My thoughts are if something happens to be accessed twice, thus needing 2 seal numbers. As in there is a seal number in Run 1 RoF and Run 2 RoF in C4. Is there a way to be able to have both seal numbers pop up on the Receipts sheet in cell D2.

I hope that is clear enough. TIA for any help. Also, since I can't seem to post attachments, likely because I'm a new member, I uploaded the sheet to my PWP.

home.comcast.net/~buddha61/Book2.xlsx

 

[buddha]

I had done some searching and found the concatenate function, and currently am trying it with a couple blank spaces instead of a slash, along with if and isblank statements..

=CONCATENATE(IF(ISBLANK('Run 1 RoF'!C5),"",'Run 1 RoF'!C5&" "),IF(ISBLANK('Run 2 RoF'!C5),"",'Run 2 RoF'!C5&" "),IF(ISBLANK('Run 3 RoF'!C5),"",'Run 3 RoF'!C5&" "),IF(ISBLANK('Run 4 RoF'!C5),"",'Run 2 RoF'!C5&" ")))

Ok, next question...

On the receipts sheet, say in cell D187, there is a line for the cash coming out of validator boxes. On the RoF sheets, there are 15 'blank' validator box areas, AP18:BH49...In there, AQ18, AU18, etc there are blank cells next to the box labeled NRT, so that when we pull boxes from them, and count them in, we can just put the NRT # it came from. Is there going to be an easy way to use D187 of receipts to look at the 15 blank cells to see if there is a box #1, and if so, pull from the total? The only other option I can think of, is to create a 4th page on the Rof sheets to make room for all 26 machines, and to specify each one individually, but feel like that will be a extra unnecessary work.