How to lookup across two tables with VLOOKUP
How to lookup across two tables by a condition is a combination of the VLOOKUP and the IF functions. The IF function handles which table and VLOOKUP handles what to search for.
Read the full article here: https://www.spreadsheetweb.com/how-to...