Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using formulas to source a value based on 2 variables
Hi there, I'm stuck on a puzzling formula I'm creating for a client, and am in 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 they want, and the month they want, it will tell me the cost of that publication in A3. I have attached my example of what I'm trying to do. All help would be greatly appreciated. Kind regards, Bsmith69 4888 +-------------------------------------------------------------------+ |Filename: Sample.zip | |Download: http://www.excelforum.com/attachment.php?postid=4888 | +-------------------------------------------------------------------+ -- bsmith69 ------------------------------------------------------------------------ bsmith69's Profile: http://www.excelforum.com/member.php...o&userid=35419 View this thread: http://www.excelforum.com/showthread...hreadid=551894 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using formulas to source a value based on 2 variables
=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" wrote in message ... Hi there, I'm stuck on a puzzling formula I'm creating for a client, and am in 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 they want, and the month they want, it will tell me the cost of that publication in A3. I have attached my example of what I'm trying to do. All help would be greatly appreciated. Kind regards, Bsmith69 4888 +-------------------------------------------------------------------+ |Filename: Sample.zip | |Download: http://www.excelforum.com/attachment.php?postid=4888 | +-------------------------------------------------------------------+ -- bsmith69 ------------------------------------------------------------------------ bsmith69's Profile: http://www.excelforum.com/member.php...o&userid=35419 View this thread: http://www.excelforum.com/showthread...hreadid=551894 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using formulas to source a value based on 2 variables
Thanks very much for your help Bob. Cheers, bsmith69 -- bsmith69 ------------------------------------------------------------------------ bsmith69's Profile: http://www.excelforum.com/member.php...o&userid=35419 View this thread: http://www.excelforum.com/showthread...hreadid=551894 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulas based on a date | Excel Worksheet Functions | |||
How do I copy & paste formulas without them linking to the source | Excel Discussion (Misc queries) | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
Problem with named formula's | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |