VLOOKUP on Multiple Columns and Return Text

File Download: https://www.excel-university.com/yt_nhnt-zruosu/

Learn Excel Fast:
https://www.excel-university.com/yt

You want to perform a lookup with VLOOKUP, but, there are multiple lookup columns. So, what are you supposed to do? Combine them into a single lookup column? That is certainly one option, but, as with just about anything in Excel, there are multiple ways. In a previous blog post, I showed one way to do this with SUMIFS when the value you want to return is a number. In this video, I'll demonstrate how to return text values when there are multiple lookup columns using a Get & Transform query.

Видео VLOOKUP on Multiple Columns and Return Text канала Excel University