Need help on how to search a table using 2 reference values, then ploting a graph.

[Guardyangel]

Hello,

When we just have the reference value one time on a Table its simple, just use the function vlookup (procv in my portuguese excel). On my case i need to search for two values at the same time, cause my table is like this:

01-II-20	Jan-12	Data needed
01-II-20	Fev-12	Data needed
01-II-20	Mar-12	Data needed
01-II-20	Abr-12	Data needed
01-II-20	Mai-12	Data needed
etc.	etc.

<tbody>
</tbody>

What line of code do i need to create that returns me the values "data needed" in order to make a graph with them?
I've tried using "=and(vlookup($I$2;$A$1:$G$27;4;FALSe);vlookup(I5;$B$1:$G$27;3;FALSe))" but the result is only the value "true" and not the data i need.

Hope i could explain well my problem, thanks.

 

[mvsub1]

Is this what you need: http://www.mrexcel.com/forum/excel-questions/548220-vlookup-two-columns-get-value-third-column.html

 

[Guardyangel]

Dont need help anymore. Found the solution here: http://www.mrexcel.com/forum/excel-questions/306615-vlookup-multiple-criteria.html

Im really surprised by the importance of pressing ctrl+shift+enter. Without that the function wouldnt work!

Regards