Re: Given X and Y Find Value in Table?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tushar Mehta (tmUnderscore200310_at_tushar-mehta.SeeOhEm)
Date: 08/18/04 

Date: Wed, 18 Aug 2004 10:44:36 -0400

What would be your objection to naming the range containing your data? 

-- 
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <006D6B39-5288-41A4-82A3-7D9A67A80777@microsoft.com>, 
John@discussions.microsoft.com says...
> Say I only had one table in the work*** and I did not want to name the 
> table.  How would I do this?
> 
> "JE McGimpsey" wrote:
> 
> > One way:
> > 
> > Name your table, including the headers (say, "table"). Then you can 
> > return the value in the table using
> > 
> >     =VLOOKUP(A1,table,MATCH(A2,OFFSET(table,,,1,),FALSE),FALSE)
> > 
> > In article <C942E2F3-7443-4563-AB33-58470C8B9ECD@microsoft.com>,
> >  "John" <John@discussions.microsoft.com> wrote:
> > 
> > > I am creating a workbook with multiple table in it.  My tables have values in 
> > > the x direction and in the y direction.  There are corresponding values that 
> > > match up givn and x number and a y number.  An example is below:
> > > 
> > > 	Y1	Y2	Y3	Y4
> > > X1	1	2	3	4
> > > X2	5	6	7	8
> > > X3	9	10	11	12
> > > X4	13	14	15	16
> > > 
> > > On a new work*** if I put in cell A1 - X1, and in cell A2 - Y3, in cell A3 
> > > I would like it to return the number located at X1, Y3 which would be 3.  
> > > What function do I use to accomplish this.
> > 
>
Quantcast