How to get values from a table matching two diiferent criteria.

**SSS86** · 10-24-2012, 05:34 PM

Hello Everyone,

Would you please tell me how can I get a value from a table that is matching two different criterias. Please see the attached equipment rate sheet. How can I get a value ($237) that is matching values in I10 and J10
Which fuction willbe best to use in this scenario? Index Matching ??

In advance thank you so much for your help.

Trial.xlsx

**protonLeah** · 10-24-2012, 06:54 PM

Please Login or Register  to view this content.

**SSS86** · 10-24-2012, 09:50 PM

protonLeah,

This is great. Thank you so much for the help. Which function did you use? Also why you inserted an extra column as 'Type'? Is it essential to insert and assign some code like 'E' as you did in this example. I noticed that you have put E in front of specific equipment not all why is that so? I am sorry, I am asking too much questions but trying to understand and learn the function you used here. Many many thanks to you again.

**protonLeah** · 10-25-2012, 12:49 AM

I don't understand.

1. Which function did you use? ----> I posted the formula in my previous post. You can also click on the cells to see the formulas.
2. Also why you inserted an extra column as 'Type'? Is it essential ... (etc.) ----> That's the same workbook you posted, I just unhid all the columns.
3. Is that your workbook?