Dear all,
First, I'd like to refer you all to the attachment, which contains my solution up to now:
Problem for review by forum.xlsx
Tab 1 shows 3 parts: green, yellow and blue.
The green part is the 'raw' data; random numbers (examples) with 3 criteria/characteristics: date, color and name (column criteria).
The yellow part being my current solution (which works, but weakness here is the column component of the VLOOKUP, which is a number instead of a formula, and therefore vulnerable to data changes).
It gets interesting at the blue part, which is my target solution: a dropdown in the upper-left corner and an INDEX-MATCH-MATCH to collect data from the green part. Using the dropdown to change value 'Name' works perfectly; a nicely tailored solution.
Finally the problem: when I apply this solution on my target data (which I unfortunately cannot share, but has the same format, only much more extensive), I get the ever returning '#N/A'.
I've made sure that the formula specifics are adjusted to the target data sheet, so I have no idea why it doesn't work.
Hard to see without the real data, I know, but do you guys have an idea what could have gone wrong?
Lots of thanks in advance!
Cheers!
Bookmarks