ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Search Target <= in Col. "B" to return Date in Col. "A" (https://www.excelbanter.com/excel-programming/443751-search-target-%3D-col-b-return-date-col.html)

u473

Search Target <= in Col. "B" to return Date in Col. "A"
 
1. An inputbox for a Target amount (Integer)
2. Search that Target in Col. "B" for <= amount, same worksheet.
3. Return a Date in Col. "A" same row.
..
I cannot use VLookup because I understand the searched value has to be
in the leftmost column. What solutions do I have ?
Help appreciated,
J.P.



All times are GMT +1. The time now is 06:42 PM.

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