Рет қаралды 82,039
This video illustrates how to perform a VLOOKUP in Excel when the lookup value is a Date Range. This is done by creating formulated "Help" columns within the data set that is being searched on.
Get a Microsoft Office 365 Personal Subscription with this Amazon link:
amzn.to/3aV9GtL
DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links.
Learn more about Excel Functions & Features with this book at Amazon:
amzn.to/3xtLmXp
To get a copy of the workbook used in this video click the link below and download it via the Excel Cave website.
theexcelcave.w...