I have a list of around 20 items and the user can pick three of them to perform a comparison, so I need a formula which gets the "TRUE" and gives me the contents of the correspondent cell in the same row. For example;
A29 = "True"
then I should get the contents of cell E29 which is London
, need this up to three occurrences to be able to complete a comparison.
How can I do this?