Using formulas to source a value based on 2 variables

[bsmith69]

Hi there,
I'm stuck on a puzzling formula I'm creating for a client, and am i
desperate need of help.
What I want to do (and have done) is set up 2 drop down menus.
My drop down menus are in column A, Row 1 and 2.

Drop down 1 - looks up a list of publications (Column C)
Drop down 2 - looks up months (Row 1, Column D-O)

What I want to do is when my client drops down the publication the
want, and the month they want, it will tell me the cost of tha
publication in A3.

I have attached my example of what I'm trying to do.
All help would be greatly appreciated.
Kind regards,
Bsmith69
488

+-------------------------------------------------------------------
|Filename: Sample.zip
|Download: http://www.excelforum.com/attachment.php?postid=4888
+-------------------------------------------------------------------

 

[Bob Phillips]

=INDEX(C1:O4,MATCH(A1,C1:C4,0),MATCH(A2,C1:O1,0))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[bsmith69]

Thanks very much for your help Bob.
Cheers,
bsmith6