Tuesday, October 14, 2008   
  Search   
 
 
Register  Login  
Forums  
     Minimize  

Welcome to MeraWindows forums.

Thank you for being at the Microsoft Windows Community Site. You may have to register before posting in forums. It's absolutely free. After registering, you can get all the benefits available to our registered members, you can access our Downloads section, you can participate in contests, etc. You can post in forums in English as well as in Hindi, in fact we encourage you to use Hindi in your posts. If you have any problem with registration or login, please contact us.
     
  


 
  Microsoft Windows Forums  Microsoft Offic...  Microsoft Excel  Lookup data in a table by row and column intersection.
Previous Previous
 
Next Next
New Post 3/14/2008 9:00 PM
User is offline Jayme
1 posts
Member


Lookup data in a table by row and column intersection. 

I have a column of cells that I would like to fill in based on the intersection of a row and column in a table. The table row and column location are identified by data I enter into other cells, can I write a formula for a cell that tells excel to enter the number from my table based on the intersection of a row and column. It is similar to looking something up on a multiplication table except that I don't know the formula used to get the table contents.
 
New Post 3/15/2008 5:00 AM
User is offline Ashish Mathur
70 posts
www.ashishmathur.com
Member




Re: Lookup data in a table by row and column intersection. 

Hi Jayme,

You should use the INDEX() function to accomplish this task.  Please read up on this function in Excel's help menu.

For Microsoft Excel trainings in India, please visit http://ashishmathur.com/training.aspx

Regards,

Ashish Mathur - View Ashish Mathur's profile on LinkedIn
Microsoft Excel MVP
www.ashishmathur.com
 
New Post 5/11/2008 9:32 PM
User is offline Shantanu
69 posts
www.thecomputernext.com
Member






Re: Lookup data in a table by row and column intersection. 

nice to find you now... :)

http://thecomputernext.com for latest Microsoft/news
 
New Post 5/11/2008 10:28 PM
User is offline Ramesh
2587 posts
Forum Guru








Re: Lookup data in a table by row and column intersection. 

Jayme Welcome to MeraWindows !!!
I hope your problem will have solved...

it's my Windows
 
 Page 1 of 1
Previous Previous
 
Next Next
  Microsoft Windows Forums  Microsoft Offic...  Microsoft Excel  Lookup data in a table by row and column intersection.
   Get Your Own E-Mail Account @MeraWindows.com Minimize  
New Page 1 New Page 1
Show your cool quotient with @merawindows.com email account
     
  
 
 
Terms Of Use   Privacy Statement  
© 2008 MeraWindows.com