Nested Vlookup

[Donald]

I need to look thru a range of data
First, look thru column A, find a match, then second find a match to a different lookup in column b to return the value in c
I am comfortable with a normal Vlookup, but how can I do a "double criteria" lookup?

 

[Aladin Akyurek]

See if this is what you need:

http://www.mrexcel.com/board/viewtopic.php?topic=16933&forum=2

 

[DonkeyOte]

simpler still is a conditional sum - array formula - this is an add-in feature.

When you set it up you will not be able to put references to a cell for matching criteria - however once you have set it up you can easily do this - so instead of say summing if currency=GBP you can have sumif currency = A2.

When you have finished editing the formula you MUST do CTRL+SHIFT+ENTER to reset the array.