I'm using Excel 2010, I have a mysql query that populate a list. I think my scenario is quite classic.
In one column I have a label: SPEC, SWD, PRD, CLOSURE... etc Then I have 10 columns that have for headers the labels. Finally I have a column in which I'd like to substitute the label name by its value but I also 'd like it loop to the columns on the left until it finds a value.
in the first column label I have the value PRD
The column named PRD is empty
The column named SWD has the value 05/02/2013
The column named SPEC has the value 21/01/2013
I'd like my last column to show 05/02/2013
I'd like to avoid VBA to populate the list but I'm not entirely close to the idea
Thank you very much for your help!