Three Way Lookup

from multiple tables

Three criteria using Column Numbers - INDEX, MATCH, MATCH

Three criteria using Column Numbers - IF Function

are these embedded ?
do you have to use an embedded if ?

Three criteria using Column Numbers - String Concatenation

Three critera using Column Numbers - Multiplication