# Return 1 value based on Multiple Criteria

#### Craig de Gail

##### New Member
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.

### Excel Facts

Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
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.

Hi Craig de Gail & Welcome,

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

Replies
6
Views
275
Replies
7
Views
1K
Replies
4
Views
370
Replies
4
Views
634
Replies
3
Views
144

1,203,128
Messages
6,053,674
Members
444,678
Latest member
Kenny_D

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back