Calc lookup [closed]

asked 2014-03-27 09:08:09 +0200

oldjingleballicks gravatar image

updated 2014-03-27 11:57:01 +0200

karolus gravatar image

I am trying to find a function in Calc that can do lookup values like in this image:

http://screenpresso.com/=wTB8f

The function I need should lookup the values in the table like this:

=MY.UNKOWN.FUNCTION('2014';'APR';C4:F6)

The formula in D14 should give 'd' as result.

I would guess this is possible, but I can not find the correct function.

Thanks for all help!

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-02-20 15:55:37.938771