Formula to lookup info in a table
James,
Create 2 more named ranges
SalesMonths - the 12 month cells (not the one to the left above the names)
SalesNames - all of the names, again not the cell above
and then use
=INDEX(Sales,MATCH(A1,SalesNames,0)-1,MATCH(A2,SalesMonths,0)+1)
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"James" wrote in message
...
if the left column is Bill, John, Joe
and the column headers are Jan, Feb, Mar.....
and the table is named Sales
A1 is named Salesman and contains John,
A2 is named Month and contains Mar
What is the best formula to lookup John's sales in March?
|