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.

FAQ

Thread Tools

Display Modes

08-10-2016, 12:53 PM

xor

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

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,100

I don't know if this can be of any use but:

=INDEX(C3:L3,N(IF(1,MATCH({1,2,3,4,5};INT(C4:L4/600);0)))) (array formula)

will return an array with your wanted result. The cell will only show YR2, but try to select the cell with the formula, then press F2 and afterwards press F9.

« Previous Thread | Next Thread »

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 05:30 AM.