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

paulzy95 · #1 09-29-2016, 07:20 PM

Hey all,

Just trying to input the column and a row of a matrix, I want the spread sheet to match them up and produce the matching result in matrix.

It is explained better in the attachment.

Cheers,

Best Regards

Paul.A

macropod · #2 09-29-2016, 08:07 PM

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

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