Reply to thread

Message: [QUOTE="Pete_UK, post: 3430862"] I would suggest that you have your reference data (1400 pipes) in a sheet called "data", and that you have the target pipe data in each of your "run" sheets. That way your formula would always reference back to one sheet, as follows: =IF(ISNA(VLOOKUP(C2,'data'!A$2:A$1400,1,0)),"","Broken "&C2) You could set up "run_x" sheet with this formula in D2 and use this as a template to produce run1, run2, run3 sheets etc, just by CTRL-drag. Then, when you add the target pipes to C2 downwards in each of the "run" sheets, all you need to do is to select cell D2 and double-click the fill-handle to copy the formula down for as many pipes as you have in that run. (The fill-handle is the small black square in the bottom right corner of the cursor). Obviously, you may need to adjust references to C and D to suit your sheet layout. Hope this helps. Pete [/QUOTE]