In one File I have a list of products with a product ID.
ID - Product
In another file I have the same product ID with a list of cross references.
Basically what you see is that T02002 has many cross references. Currently when doing a V-Look Up it only shows one cross reference - even when there is more than one.
So my question is...how can I get the V-Look up to work more like an Access Database? If all else fails I'll use Access but the person Im doing this for is more comfortable with using Excel.
Any help is greatfully received!