Did search the web and here of course, but found several VLOOKUP and MATCH e.t.c samples, but not the way I need.
I have a table and the first Column got the question but is also the column to find the answer.
In the added sample book there is a table with the desired result. The third Table.
Any suggestions to get it done?
The problem is also that I cant use a hidden column between the two data and result column. The two table column are in a greater whole and can't change that to avoid mess up the underlaying parts.
As always, thank you
Bookmarks