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-02-2017, 01:17 PM

Highlander01 Highlander01 is offline

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

Office 2016

Novice

Join Date: Jan 2016

Location: Portsmouth, England

Posts: 18

Quote:

Originally Posted by NBVC

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

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 08:37 AM.