Jorge Lowry
Active Member
Joined: May 24, 2024
Follow
RE: How to Return a Value from a Range Based on a Date Lookup in Excel?
The formula is basically: =LOOKUP(2,1/(Column1<=LookupDate)/(column2>=LookupDate),column3) where LookupDate is your lookup date, column 1...
8 months ago
Replies: 2
Views: 86
Replies: 3
Views: 74
RE: Multiple Criteria for Production Level 3
In the Efficiency Rate column for Level 3 machines (identified in the Machine Level column), you can use a nested IF statement to consider the purchas...
11 months ago