Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-29-2016, 07:20 PM
paulzy95 paulzy95 is offline Input column and row of a matrix, I need the aligning result output Windows 7 32bit Input column and row of a matrix, I need the aligning result output Office 2016
Novice
Input column and row of a matrix, I need the aligning result output
 
Join Date: Aug 2016
Posts: 9
paulzy95 is on a distinguished road
Default Input column and row of a matrix, I need the aligning result output

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
Attached Files
File Type: xlsx Matrix Excel.xlsx (9.3 KB, 11 views)
Reply With Quote
  #2  
Old 09-29-2016, 08:07 PM
macropod's Avatar
macropod macropod is offline Input column and row of a matrix, I need the aligning result output 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,366
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

In C2:
=OFFSET(G3,MATCH(B2,G4:G8,0),A2)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Column Aligning w/o Tables ShankedS Word 3 11-30-2015 08:44 PM
Input column and row of a matrix, I need the aligning result output Row and Column name in matrix ankush Word 1 07-21-2015 03:39 AM
Input column and row of a matrix, I need the aligning result output Input from excel, output to word conradin Word 3 04-20-2011 07:48 PM
Input column and row of a matrix, I need the aligning result output 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 07:14 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft