Hello there,

I have a excel sheet (sheet 1) of products 10 columns across. Each product
has a code for example VOD/01. I use vLookup's in another sheet (sheet 2)
which pulls in various data from cells in sheet 1. I use this to pull up a
list of equipment that is needed.

Some products need other products to work correctly. Link two products
together in sheet 1 and when it's added to sheet 2 a message appears to
remind me that another product is needed?

If that have confused you nothing will.