Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 06-02-2017, 01:17 PM
Highlander01 Highlander01 is offline Formula to return a value of 1,2,3 or based on a set criteria Windows 10 Formula to return a value of 1,2,3 or based on a set criteria Office 2016
Novice
Formula to return a value of 1,2,3 or based on a set criteria
 
Join Date: Jan 2016
Location: Portsmouth, England
Posts: 18
Highlander01 is on a distinguished road
Default

Quote:
Originally Posted by NBVC View Post
Like this:

=LOOKUP(DATEDIF(L5,TODAY(),"m"),{0,4,6,12},{1,2,3, 4})
I tried this today and hey presto. Thank you very much.

Appreciated!

Gordon
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to return a value of 1,2,3 or based on a set criteria Return Max Text or Number Value based on Criteria kwilson307 Excel 1 04-20-2017 05:07 AM
Formula to return a value of 1,2,3 or based on a set criteria Sum based on multiple criteria (one of the criteria is not unique) until a threshold is reached. phillipsdp Excel 1 11-09-2016 12:53 AM
Select value from table based on two criteria gebobs Excel 4 07-21-2016 08:26 AM
Formula to return a value of 1,2,3 or based on a set criteria How to return a value in a data table using vertical and horizontal criteria oswald Excel 1 02-08-2015 02:01 AM
Change values in cells based on criteria SaneMan Excel Programming 2 02-02-2012 07:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:54 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft