Combo VLOOKUP and HLOOKUP

[hannes]

I have this issue:


I received data in this format

ID JAN FEB MAR APR etc.
33 2002 7 8 9 9
33 2003 5 6 7 8
33 2004 4 5 7 8
34 2003 5 6 7 8
34 2004 4 5 7 3


Basically I need to have a lookup towards the ID and then it should check for the particular month in a particular year, how could this be done?

The problem is that from the whole data set of three years sometimes only one or two years are available.


Thank you!

[hannes]

Is MATCH and INDEX maybe applicable in this case and if so how?

[olasa]

Here are two different solutions:

Please Login or Register  to view this content.

In case of errors. The 1st formula will return 0. The 2nd #N/A. To prevent the 2nd error use =IF(ISERROR(...),"", ...)

Hope this helps

Ola Sandström