Return 1 value based on Multiple Criteria

[Craig de Gail]

Here is my problem. Hope someone can help.

I need to return one value, based on 3 criteria, from 3 different locations in an associated worksheet in the same workbook.

This is what I have devised so far, but this formula is returning a value from a place where it shouldn't be:-

=VLOOKUP($B8,'1SD_All AAS'!$A:$F,4,SUMIF('1SD_All AAS'!$C:$C,$A$6:$A$15,'1SD_All AAS'!D:D))

Thanks to anyone who can help with, I dont beleive it is a simple Vlookup formula because of the multiple conditions. But i do think it is a combination of a couple of nested functions.

 

[hkaplan2]

What is that formula returning for a value? It does not appear to be structured properly as a vlookup.

=VLOOKUP($B8,'1SD_All AAS'!$A:$F,4,SUMIF('1SD_All AAS'!$C:$C,$A$6:$A$15,'1SD_All AAS'!D:D))

syntax is:

vlookup(this_value,in_this_table,return_this_column,true or false)

I don't get your sumif in the formula. After the 4 (column to return), you should have true or false.

 

[shemayisroel]

Hi Craig de Gail & Welcome,

Could you please post some sample data to work with and expected result(s)