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.

And your question is?

"James Symonds UK" wrote:

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.

A table with the dependencies would be integral to accomplishing this.

Seems that vlookup would also be a key part.

--
Regards,
Tom Ogilvy


"James Symonds UK" wrote:

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.