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 had tried a nested IF statement, but as soon as one of the values is true, it stops reading the rest, and I need it to copy all cells if they have a value, and if possible, separated with a /

I hope that is clear enough. TIA for any help. Uploaded is a book with the relevant sheets.

[buddha]

I think I have solved my own issues with some searching by using...
=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&" "))) though it puts 2 spaces vs a slash since I didn't know how to not end in a slash if another number wasnt pulled.

[buddha]

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. Going to try to think of a way right now as well.

I basically need it to check 15 cells on 4 different sheets, though the cells to check are teh same on each sheet, and if it is what is needed, I want it to pull the total. Possible?