Vlookup with Criteria

dear friends,
please help me with to solve this query;

i have attach the sheet and i need a formula in coloum C where it match coloum A folio number with coloum L folio # and if find give the value from coloum N but the other condition to match is that while match the coloum L it sould paste the value where date is greater than given in coloum B. a scenario is define in sheet.

please let me know if i am unable to explain.

regards

You can use this array* formula in C3:

=INDEX($N$3:$N$7,MATCH(1,(A3=$L$3:$L$7)*(B3<$M$3:$M$7),0))

* An array formula needs to be committed using the key combination of Ctrl-Shift-Enter (CSE) instead of the usual <Enter>.

Hope this helps.

Pete

Hi,


Go through the attached file.

Hi Pete,

For some reason the formula is not working.

Did you use CSE to commit it? You should see curly braces { } around the formula when viewed in the formula bar but you should not type these yourself.

If you do not see them, press F2 while on that cell, then hold down the CTRL and SHIFT keys and press ENTER.

Hope this helps.

Pete

Done sir
Thankyou

dear all friends,
thankyou all and really appreciated efforts you guys made.

god bless you

regards