Apr 14 2021 03:23 AM
Apr 14 2021 06:04 AM
SolutionNot sure if that's what you're looking for. Without a file (without sensitive data) it is difficult to guess what the user wants.
If nothing is what you are looking for, please include a file and a detailed explanation.
=IF(A1=Sheet2!A1,Sheet1!A3,Sheet1!A1)
Please see the inserted file
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Apr 14 2021 06:44 AM
Apr 14 2021 10:36 AM
INDEX/MATCH shall work if in C are unique values. Better to have sample file to illustrate on concrete formula. It also depends on which version of Excel you are, in general on 365 or not.
Apr 14 2021 06:04 AM
SolutionNot sure if that's what you're looking for. Without a file (without sensitive data) it is difficult to guess what the user wants.
If nothing is what you are looking for, please include a file and a detailed explanation.
=IF(A1=Sheet2!A1,Sheet1!A3,Sheet1!A1)
Please see the inserted file
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.