my apologies if a similar question is already here, but i could find it that
quickly.

i need to lookup a value in the following situation
a b c d e f
1 45 6 78 6 0%
5 6 7 77 7 1%
5 7 4 7 8 2%
etc.

the function needs to determine the column by comparing it to a value in the
table where the result should go. next, in this column it should look for
another value (set elsewhere). from this row the function than needs to
return a percentage (always the last column in the array)

any hints? i used several combinations of (v)lookup and/or index and match,
but i can't get it to work