Sep 27 2021 09:07 PM
Hi There, I hope everyone fine there. I am at beginner level using Excel 2019 on MacBook Air.
I have come across a situation:
I have created a data base using Hierarchies. if value is selected in cell A1 and another value is selected in Cell B1. I want excel to compare these two values and return the value in C1.
For Example:
A1 = A
B1 = B
than C1 should be = C
Sep 28 2021 09:00 AM
Do you mean in C1 it shall be some formula which returns value based on values in A1 and B1 ? If so why "C" shall be returned, not "D" or "Z" ?
Sep 28 2021 09:57 AM
The formula is always placed in the destination cell and sets the rules by which the value returned is to be calculated. A general method might be through the use of a 2D lookup table.
but IF formulas would also offer a solution in some cases.
Oct 02 2021 05:02 AM
SolutionOct 02 2021 05:10 AM
Thank you, but I still don't catch what is the logic to generate " resulting from combination of A and B".
Let assume in A1 is 10 and in B1 is 11; or in A1 is "Joe" and in B1 is "Mary" - what shall be returned?
Oct 02 2021 06:54 AM
Oct 02 2021 07:14 AM
Is it possible to share sample file? It's not clear where provided data is located and in which form. In particular how Joe and Mary are connected to Smith in these records.
Oct 13 2021 07:00 PM
Oct 14 2021 03:04 PM
Oct 15 2021 11:34 PM
Oct 16 2021 08:03 PM
Oct 02 2021 05:02 AM
Solution