Need a formula (possibly something like VLOOKUP) that will return multiple results.

		Microsoft Office Forums > Microsoft Excel > Excel
Need a formula (possibly something like VLOOKUP) that will return multiple results.

08-10-2016, 08:55 AM

SilverUnicorn79 SilverUnicorn79 is offline

Windows 7 32bit Need a formula (possibly something like VLOOKUP) that will return multiple results.

Office 2013

Novice

Join Date: Aug 2016

Posts: 5

Need a formula (possibly something like VLOOKUP) that will return multiple results.

Is there an Excel formula (or combination thereof) that will return all of (only) the first years that my data crosses the next multiple of the threshold?
Also, can I then do a SUMIF function on the premis that (if A8 contains "YR4"…)?

Also posted at:

http://answers.microsoft.com/en-us/o...=1470850338622

http://www.excelforum.com/editpost.p...postid=4453160

Attached Files

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to make MATCH/INDEX formula return multiple successive responses.	danigirl121	Excel	7	06-08-2016 01:57 PM
Excel Formula for Multiple Conditions & Results	nowco	Excel	4	03-16-2016 11:24 AM
formula needed to sum weeknum results from multiple worksheets	JOJO101	Excel	0	06-27-2015 11:06 PM
Vlookup returns inconsistent results	Jhnsnkth527	Excel	0	04-16-2015 12:36 PM
Possibly a VLookup	mrswarrick	Excel	3	01-13-2012 11:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:37 PM.