Hello ALL
I am getting stuck with the formula for using Less than or equal to and greater than or equal to formula.
If an age is in a certain range I would like to return that range
Attached you will see the example of the start of the formula , but I am not sure how to write the formula
Thank you in advance
Try Cell B2 formula , Drag down
ORHTML Code:
HTML Code:
Last edited by wk9128; 08-31-2021 at 10:55 AM.
Thank you wk9128
Add extra column D with lower limit of each bracket
in B2
=INDEX($C$2:$C$9,MATCH($A2,$D$2:$D$9,1))
Thank you John , I never thought of using index and match
Same logic but more calculations ... in B2 and filled down.Formula:
=LOOKUP(A2,--LEFT($C$2:$C$9,FIND("-",SUBSTITUTE($C$2:$C$9," ","-"))-1),$C$2:$C$9)
Dave
Simpler than my previous and fewer calculations.Formula:=LOOKUP(A2,--LEFT(SUBSTITUTE($C$2:$C$9,"-"," "),3),$C$2:$C$9)
Thank you Flame Retired
You are welcome.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
@Ron Purpura You're Welcome. Glad to help . Thank You for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks