Lookup: 2 criteria

M

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple lookup criteria 3
Look up in another sheet for values to return in 1st worksheet 2
Use array for lookup value, to return array of lookups 4
Calculating Monthly returns based on Dates 4
Calculating the mode of a criteria-based range 20
lookup? 1
Look up two values in different columns and return matching value 5
Multi Part Lookup 3

Top