Need Help With Formula

[it's an excel world]

Hello all,

I need a formula that will accomplish the following...

I want to look in cell AQ2 and if it is not blank, I need to look at the values in cells A4 & AN4. Then look down both columns A & AN until I locate the last row in which the values in columns A & AN mirror those of cells A4 & AN4, and return the value in column D of that particular row.

I hope this information is sufficient.

Thank you in advance!

 

[T. Valko]

Hi T. Valko,

I was hoping you could explain to me or point me in a direction to better understand exactly what your formula is telling excel to do. I think I understand the index and lookup portion, but am curious about the the 2,1 prior to the lookup and the last part with ROW(A6:A15))))

Thanks for all you help!

See if this helps...

This page describes many techniques for finding the last item:

http://xldynamic.com/source/xld.LastValue.html

And this section of that page describes the technique I used:

http://xldynamic.com/source/xld.LastValue.html#S012