Hi !

I am looking for a formula, probably a vlookup that would find a value corresponding to two criteria.

The formula that I though would work is:

=VLOOKUP(A3&$B$2;CHOOSE({1;2};F14:F34&G14:G34;I14:I34);2;0)

It is supposed to find back the value that would correspond to the date and the segment.

Is there anything wrong in my formula already?