View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Selecting a cell based on a criteria

I thought that might be the case.

Are you PizzaFriend as well?

=OFFSET(A1,MATCH(Item,A2:A20,0),MATCH(Month,B1:M1, 0))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"pmundle" wrote in message
oups.com...
A correction for the previous post.B1:B13 is wrong.I mean,Row 1.
Cells B1,C1,D1, ....M1.for Jan to Dec.