I'm having a bit of an excel nightmare I have been sent a file with a number of products in the first row(product codes) and in the first column(related product codes). In any of the other cells could be an "X" showing that the products are related. What I am wanting to do is to lookup the column for cells marked with an "X" and display the matching product code that is in that row.
There is a link below to an mockup spreadshet which should make sense as it's not the easiest problem to describe.
http://petersenuploads.co.uk/bell/excelexample.xls
