Input column and row of a matrix, I need the aligning result output

		Microsoft Office Forums > Microsoft Excel > Excel
Input column and row of a matrix, I need the aligning result output

09-29-2016, 08:07 PM

macropod

Windows 7 64bit Input column and row of a matrix, I need the aligning result output

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,521

In C2:
=OFFSET(G3,MATCH(B2,G4:G8,0),A2)

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Column Aligning w/o Tables	ShankedS	Word	3	11-30-2015 08:44 PM
Row and Column name in matrix	ankush	Word	1	07-21-2015 03:39 AM
Input from excel, output to word	conradin	Word	3	04-20-2011 07:48 PM
Need to search a column for a macth and return a result from a third column	pdfaust	Excel	2	02-03-2011 03:02 PM
Creating A Input Or Output Field	skoz55	Excel	0	08-15-2009 04:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:54 PM.