index search

in match you can choose both rows to lookup with ampersand in  between 

but you need
control shift enter curly brackets keep in memory unless press enter go back value error

also in double index method without c+s+e put ampersand between data labels you actually look up in

helper cells make a row combine names of both rows to make it go one way

data validation allows dropdown of different formulas like profit or revenue
make sure include match function selecting the interface with the drop down not just referring to the table. otherwise values wont change with dif dropdown