Google Sheets Non Adjacent Lookups 

This video looks at creating a Non-Adjcent Lookup Formula that is still Dynamic. In other words, creating a Lookup when the Lookup Columns are not parallel to the results columns. This lesson shows how this can be done without having to change the original dataset.
Learn more about Google Sheets Functions with this Book at Amazon.
amzn.to/3HkHcGa
Buy the complete Google Workspace User Guide at Amazon:
amzn.to/3Hr9dLW
DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links
#GoogleSheetsAdvanced
#googlesheetstips
#googleSheetshacks