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, 12:59 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

Does this work?

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

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 02:00 PM.