Best way:

Pivot Table

Formula way:

=VLOOKUP(A1,Sales,MATCH(TEXT(A2,"mmm"),OFFSET(Sale s,,,1,),0),0)



In article ,
"James" wrote:

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?