You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I can't figure this out. I want to be able to type a date into E2 (GREEN) and have F2 (BLUE) return the value $30 (from C5) because that's the value when E2 is between that START DATE and END DATE.
For example, if the user puts 08/13/2024 into E2, F2 would return $50.
What's the formula to put into F2?
Thank you for any help.
Mac Studio (2023)
You can also use XLOOKUP with the 'exact or next smallest' parameter.
Input in F2 as:
=XLOOKUP(E2,A,C,"NF",-1,1)
Note that this does not use column B, since the date ranges are implicit in Column A.
More on XLOOKUP here:
SG
Hi REFLUXER,
Here is one way.
Format the Date cells (column A, Column B and D1) as Text. Numbers will recognise them as Dates, but without the automatic Time component that may complicate this method.
Enter the date in question in D1.
Formula in D2 (and fill down) is IF(AND(A2≤D$1,B2≥D$1),"Yes","No")
Formula in E2 (and fill down) is IF(D2="Yes",C2,"")
Regards,
Ian.
What a simple and elegant solution - thank you!
Thank you for your help
looking up value if provided date falls between two dates
