As explained by Rory, all 3 criteria are located in Column A ... and, as stated in message # 2, in my opinion ...

you should take the time to fully master the difference between using the AND logic ... versus using the OR logic ...

You…]]>

thank you for the reply, just for understanding, why the formula works if i use<> , the only difference between the two formulas is that <> is missing

As explained by Rory, all 3 criteria are located in Column A ... and, as stated in message # 2, in my opinion ...

you should take the time to fully master the difference between using the AND logic ... versus using the OR logic ...

You have not explained the exact calculation you want to get ... most probably you need the OR logic ...

]]>Now, despite your sample workbook, still cannot actually see what is the structure of your final output....]]>

Now, despite your sample workbook, still cannot actually see what is the structure of your final output....

]]>Could you explain even further the detailed relationship between the cells ...?

It seems to me you are after creating mutually exclusive cells...

Is that right ...?]]>

Could you explain even further the detailed relationship between the cells ...?

It seems to me you are after creating mutually exclusive cells...

Is that right ...?

]]>Hello,

Since we are dealing with an

It would nice ..

Hello,

Since we are dealing with an **IF** statement ...

It would nice .. **IF** you could post your feedback ...

Thanks for your Thanks ...

Thanks for your Thanks ...**AND** for the **Like**

Hello,

Two comments :

1. Did you see the message # 5 ... formula is already adjusted ...

2. To understand the mechanics of the combination Index / Match for a two-way lookup :

https://www.excel-easy.com/examples/two-way-lookup.html

Hope…]]>

Could you help me understand the formula a little better so I can expand it down to 886 rows and also many columns to the right?

Hello,

Two comments :

1. Did you see the message # 5 ... formula is already adjusted ...

2. To understand the mechanics of the combination Index / Match for a two-way lookup :

https://www.excel-easy.com/examples/two-way-lookup.html

Hope this will help

]]>Thanks a lot for your Thanks ...

Thanks a lot for your Thanks ... **AND** for the **Like**

Thanks for your Thanks ...

Thanks for your Thanks ...**AND** for the **Like**

Curious to know how the next episode unfolds ... and if the final outcome is up to your expectations ...]]>

Curious to know how the next episode unfolds ... and if the final outcome is up to your expectations ...

]]>Okey, thanks for your valuable advice.]]>

Okey, thanks for your valuable advice.

]]>CONGRATULATIONS on your CREATIVITY to come up with the most Uncommon Excel challenges ....

Thanks for Thanks ...

I AM CRYING OF HAPIINESS :') THANK YOU!

CONGRATULATIONS on your CREATIVITY to come up with the most Uncommon Excel challenges ....

Thanks for Thanks ... **AND** for the **Like**

Please give an example of what this means using the data you supplied. I am not sure what you are asking and what you wish to be displayed. Smaller samples with a before and after scenario would seriously help to get your a bona fide solution.]]>

Quote

I want to know what those matching common part number is for all of the suppliers.

Please give an example of what this means using the data you supplied. I am not sure what you are asking and what you wish to be displayed. Smaller samples with a before and after scenario would seriously help to get your a bona fide solution.

]]>Thanks A LOT ... !!!

YOU made my DAY ...!!!]]>

I'M CRYING OF HAPPINESS NOW

Thanks A LOT ... !!!

YOU made my DAY ...!!!

]]>Thank you Rareskyfive, this one is also what I was exactly looking for. You just made my day.]]>

**Formula** is: **Sell Price** = **Cost** / (1- Margin %). In your example, 24.9/(1-. 85) will give you a **selling price** of 166.

Thank you Rareskyfive, this one is also what I was exactly looking for. You just made my day.

]]>X post

mrexcel.com/board/threads/xloo…-in-return-array.1165619/]]>

X post

]]>There are several variances ....

see following link :

https://www.educba.com/excel-variance/

Hope this will help

]]>

There are several variances ....

see following link :

https://www.educba.com/excel-variance/

Hope this will help

]]>