How to find a value based on 2 criteria that are in the same other column

smetu

Board Regular
Joined
Jun 12, 2013
Messages
54
Office Version
  1. 365
Sorry, I don't even know how enunciate my problem and that's why I cannot find any solution for it on the Internet.
So I've created a very simple table to give you a very simplified example of what I need to do and I will translate it to my real excel file.

Basically without changing anything in the table - because my real data in my real excel file are fixed, I need to be able to write a formula in the green cell to find the price of the Pink Shoes.
If someone can help me, it would save me!

Thank you to anyone who will accept the challenge!
 

Attachments

  • Pink Shoe Price.jpg
    Pink Shoe Price.jpg
    19.5 KB · Views: 10

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)
 
Upvote 0
How about
Excel Formula:
=SUMPRODUCT((B2:D4=D8)*(B1:D1=C8),A2:C4)
 
Upvote 0
Solution
You're welcome & thanks for the feedback.
 
Upvote 0
You're welcome & thanks for the feedback.
I have another one if I may.
Is there a way to find a formula again in the green box based on the grey and yellow boxes.
The fact that the transaction ID's of Fund I and Fund II are not in the same columns prevents me to find a solution to this problem.....
 

Attachments

  • Screenshot 2023-03-21 201637.jpg
    Screenshot 2023-03-21 201637.jpg
    65 KB · Views: 3
Upvote 0
As you have started a new thread for this question, you need to stick to it. Thanks
 
Upvote 0

Forum statistics

Threads
1,213,521
Messages
6,114,104
Members
448,548
Latest member
harryls

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top