I am trying to use LARGE function with VLOOKUP function and except for the
case where k=1, I am getting a €œ#NUM!€� message€¦

The idea is to use a conditional function (like IF) and the logical test is
to evaluate if certain number is 1st, 2nd or 3rd of a group of values. But
the group of values is not €œstable€�, i.e. the number of arguments to compare
with varies according to a text criteria. Thats why I am using the VLOOKUP€¦

So, the formula I used is the following:

=IF(F12=LARGE(VLOOKUP(D12;$D$12:$F$30;3;FALSE);1); 1;0)

Column F has numbers
Column D has text

Does anyone have an idea how to solve this?