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.
|