Thread: look for a pipeID in a column and returns "broken" result
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Pete_UK
 
Posts: n/a
Default look for a pipeID in a column and returns "broken" result
Assume your pipeIDs are in column A from A2 to A1400. Assume your
Target pipes are in column C, beginning with C2. Enter this formula in
D2:

=IF(ISNA(VLOOKUP(C2,A$2:A$1400,1,0)),"","Broken "&C2)

Copy the formula down for as many items as you have in column C.

Hope this helps.

Pete

Reply With QuoteReply With Quote