ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   VLOOKUP within a Range of Dates (https://www.excelbanter.com/excel-worksheet-functions/447933-vlookup-within-range-dates.html)

wgmills

VLOOKUP within a Range of Dates
 
I have data in mutiple columns. It is a Bid Log for a construction company. So it is in date sequence (Column A - dates). I need to be able to look up data in other columns within a defined date range within Column A. In other words, I need to be able to isolate a range within a month, but my column A dates cover over a year. You assistance would be appreciated.

Spencer101

Quote:

Originally Posted by wgmills (Post 1608373)
I have data in mutiple columns. It is a Bid Log for a construction company. So it is in date sequence (Column A - dates). I need to be able to look up data in other columns within a defined date range within Column A. In other words, I need to be able to isolate a range within a month, but my column A dates cover over a year. You assistance would be appreciated.

Turn on "Auto Filter" and use that to restrict the data to just what you need to see?

If that doesn't fulfil your requirement then perhaps an example workbook would help us provide you with an answer.


All times are GMT +1. The time now is 11:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com