How to make MATCH/INDEX formula return multiple successive responses.

		Microsoft Office Forums > Microsoft Excel > Excel
How to make MATCH/INDEX formula return multiple successive responses.

FAQ

Thread Tools

Display Modes

06-07-2016, 09:48 PM

macropod

Windows 7 64bit How to make MATCH/INDEX formula return multiple successive responses.

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

If you insert 5 columns after column A on the 'Data' sheet and change the 'Data' sheet name to match your own, the references in the formulae in the '500' and '508' sheets will update to match your needs.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tags

index match

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
index / match Formula	dmcg9760	Excel Programming	1	11-08-2015 03:16 PM
UDF multiple IFs INDEX-MATCH	grexcelman	Excel Programming	0	02-22-2015 04:20 PM
Excel Formula: return a range of cells that match	tinfanide	Excel	4	08-30-2014 07:03 AM
Complex Formula using INDEX and Match needed	OTPM	Excel	5	05-23-2013 01:22 AM
Help with multiple match and index formula	ryanwood	Excel	1	09-12-2012 07:53 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:37 AM.