VLOOKUP is a righty, can’t go left.*Īnd this brings us to the reason we are here, to get the hang of using the INDEX/MATCH combination to return values that lie to the left of the lookup column. That is, the return column lies to the left of the lookup column. The problem is that in the lookup range, the CustName column lies to the left of the CustID column. We would like to look up the CustID from the Customers table, and return the CustName. We are trying to populate the report’s CustName column. Note: depending on your version of Excel, you may have XLOOKUP as an option … more info here: Overview This is a perfect time to move beyond the VLOOKUP function and explore the INDEX and MATCH functions. If you have ever tried to return a value that physically lies to the left of the lookup column, you quickly realize that this task is difficult to accomplish with the VLOOKUP function.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |