Forum Discussion
Solved
Lookup or else
Hi, i can't solve this and i can't even search for the answer cause i don't know how to explain it right.
On the base of 2 answers (green), it has to give a result (yellow) took from a matrix.
Please help me :-)
Michel,
that is a two-way-lookup. It can be done in many ways.
=LOOKUP(2,1/(K12:K15=G13)/(L12:L15=H13),M12:M15)
2 Replies
Michel,
that is a two-way-lookup. It can be done in many ways.
=LOOKUP(2,1/(K12:K15=G13)/(L12:L15=H13),M12:M15)
- Thanks so much!!!
