palacesports

asked on

# Excel Formula Question

I have an excel spreadsheet that has three columns of data and I need to return the value in the third column based on criteria in the other two. For example:

Col1 Col2 Col3 Col4

1 2 asdf zxcv

1 2 qwer zxcv

1 1 zxcv zxcv

1 2 asdd zxcv

2 2 qwds qw32

2 1 qw32 qw32

3 1 asert asert

3 2 qwed asert

3 2 qwxa asert

3 2 saew asert

Column 4 is where the formula should go and those are the values that should be returned. The idea being that the formula will evaluate column2 (looking for the minimum value) where the values in column1 are equal and place the corresponding value in column 3 in column 4.

Thanks.

Col1 Col2 Col3 Col4

1 2 asdf zxcv

1 2 qwer zxcv

1 1 zxcv zxcv

1 2 asdd zxcv

2 2 qwds qw32

2 1 qw32 qw32

3 1 asert asert

3 2 qwed asert

3 2 qwxa asert

3 2 saew asert

Column 4 is where the formula should go and those are the values that should be returned. The idea being that the formula will evaluate column2 (looking for the minimum value) where the values in column1 are equal and place the corresponding value in column 3 in column 4.

Thanks.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Thanks Barry. It was the CTRL+SHIFT+ENTER validation step that I messed up. I didn't validate the formula after I modified it.

ASKER

Thanks for the quick response! That is an impressive formula. For some reason I'm receiving a "value not available error" in my spreadsheet with this formula. I've stepped through the formula and it seems to evaluate how I would expect it to, but the end result is "INDEX($C$2:$C:$C$11,#N/A)

Thanks.