Formula to lookup info in a table - part 2
There is an Intersect method in Visual Basic that
determines if two ranges intersect each other.
-----Original Message-----
Thanks for all your great answers.
Isn't there an Intersect function?
I think this should be:
=INTERSECT(Sales,Salesman,Month)
=INTERSECT(range_name,row_label,column_label)
can I DL a custom function?
Tom:
=INDEX(Sales,MATCH(A1,INDEX(Sales,0,1),0),MATCH(A2 ,INDEX
(Sales,1,0),0))
Bob:
=INDEX(Sales,MATCH(A1,SalesNames,0)+1,MATCH
(A2,SalesMonths,0)+1)
JE McGimpsey
Pivot table:
=VLOOKUP(A1,Sales,MATCH(TEXT(A2,"mmm"),OFFSET
(Sales,,,1,),0),0)
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?
.
|