index matching with multiple columns

**hobgob123** · 10-14-2008, 01:43 PM

\1

I'm trying to have a cell where I return the minimum value of column A but only when column B equals 380 and when C equals 80. I know how to do it if I select my range manually to be the range including all the 380's and 80's but I'd like to select the entire data set to look through so that I can easily change the criteria to say finding the minimum in Column A when B equals 420 and C equals 40.

**snasui** · 10-14-2008, 02:13 PM

Try this,

Suppose D1=420, D2=40

D3

Please Login or Register  to view this content.

Ctrl+Shift+Enter not just enter.

**snasui** · 10-14-2008, 02:13 PM

..........

**hobgob123** · 10-14-2008, 07:30 PM

works great. thanks for the help!

**shg** · 10-14-2008, 07:34 PM

Please mark the thread as Solved if it indeed is.

**hobgob123** · 10-14-2008, 07:35 PM

how do you mark as solved?

**shg** · 10-14-2008, 07:40 PM

Click the Edit button for the post, click Go Advanced, and the select SOLVED from the drop-down. It's too late for you to edit the post; I'll take care of it.