Thread: Need a formula (possibly something like VLOOKUP) that will return multiple results.
View Single Post
 
Old 08-10-2016, 08:55 AM
SilverUnicorn79 SilverUnicorn79 is offline Windows 7 32bit Office 2013
Novice
  
Join Date: Aug 2016
Posts: 5
SilverUnicorn79 is on a distinguished road
Default 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
File Type: xlsx Excel Formula Question.xlsx (11.2 KB, 10 views)
Reply With Quote