Lookup: 2 criteria

[maca]

Hi,

Is it posible to search with lookup after 2 criteria?
Inputs:
An array(column) of dates and an array of monthly returns.
Outputs:
Rows of the returns corresponding to the each year of data as follows:
First row:
in the first cell the return corresponding to the first month, in the second, the return corresponding to the second month, etc.
The next row should be similar to the first one.
So I have to search after 2 criteria: the year and the month of the date.
How can I solve this issue?

Rgds,
Maca.

[Gary's Student]

Take your two criteria and CONCATINATE them. The resulting column will
contain the same info as the two original columns. Then use VLOOKUP, which
can look-up based upon text.

Good Luck
--
Gary's Student


"maca" wrote:

>
> Hi,
>
> Is it posible to search with lookup after 2 criteria?
> Inputs:
> An array(column) of dates and an array of monthly returns.
> Outputs:
> Rows of the returns corresponding to the each year of data as follows:
>
> First row:
> in the first cell the return corresponding to the first month, in the
> second, the return corresponding to the second month, etc.
> The next row should be similar to the first one.
> So I have to search after 2 criteria: the year and the month of the
> date.
> How can I solve this issue?
>
> Rgds,
> Maca.
>
>
> --
> maca
> ------------------------------------------------------------------------
> maca's Profile: http://www.excelforum.com/member.php...o&userid=24892
> View this thread: http://www.excelforum.com/showthread...hreadid=392128
>
>