Ok, i've looked using the search tool and i think i didnt found anything similar, but how i can search for a combination in an aray
for example
xxxxxxxx |john| |mike| |martin| |josh|
ana-------- |love| | hate | |friends| | crush|
christine |love| |friends | |firends| |meh...|
valentine |hate| |firends| | love| |hate|
charlotte |hate| |friends| |crush |crush|
so, in this example (do not judge anyone feelings or behaviours) how can i look what valentine feels for martin?
or what josh feels for ana?
i hope you can help me because C2 said no programing required, but they didnt said that you still need everything else xDD
byt the way, lets look at this "array"
if instead of numbers i have another values, how can i find out the result of the column and row?
thanks in advance!