In this video we show how the XLOOKUP function can return multiple arguments when data for each item is in different rows (not columns) and how XLOOKUP can extend the VLOOKUP function with the TRUE argument.
These are the two files needed to follow along to this video:
Excel With Wayne is an online Microsoft Excel Training Course taught by Dr. Wayne Winston. Dr. Winston is the world’s foremost Microsoft Excel Expert that teaches at some of the world’s largest organizations including Microsoft and government organizations such as the Navy and Army.
Please confirm you want to block this member.
You will no longer be able to:
Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.
