Formula to return a value of 1,2,3 or based on a set criteria

		Microsoft Office Forums > Microsoft Excel > Excel
Formula to return a value of 1,2,3 or based on a set criteria

06-01-2017, 01:56 PM

NBVC

Windows 7 64bit Formula to return a value of 1,2,3 or based on a set criteria

Office 2007

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

Like this:

=LOOKUP(DATEDIF(L5,TODAY(),"m"),{0,4,6,12},{1,2,3, 4})

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Return Max Text or Number Value based on Criteria	kwilson307	Excel	1	04-20-2017 05:07 AM
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
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 06:56 AM.