Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding a value in a cell matching up with a column/row
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding a value in a cell matching up with a column/row
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) "BZeyger" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding matching cells between two workborks and updating cell con | Excel Worksheet Functions | |||
Finding matching cell data | Excel Worksheet Functions | |||
Finding the cell reference of a matching search value | Excel Worksheet Functions | |||
Finding Matching Records in a Column | Excel Programming | |||
Matching cell in one column to value in another | Excel Programming |