Finding a value in a cell matching up with a column/row

B

BZeyger

I am tring to figure out how to find a value in a cell. the first Column a
wold consists of values and the first row would be the year. I need to find
the value that corrospondes with teh year.
For Example

2005 2006 2007 2008

Price 2 3 4 5

Rate 4 5 7 2

Total 8 15 28 10

I need to find the value of the Total in 2007

How can this be done? either by code or by formula.
 
C

Chip Pearson

If you have your year numbers in A1:E1 and your Price/Rate/Total headers in
A2:A5, then the following formula will return the Price for 2007.

=OFFSET(A1,MATCH("Price",A2:A5,0),MATCH(2007,A1:E1,0)-1,1,1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Finding the right style field in VBA 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
Finding the proper style field and the numbered paragraph value within the style 0
Find matching cell and return value of a different cell 5
Need Help with a VBA subroutine 0
Cumulative formula for word table 0
Named cells in an array to a column and to a row 3

Top