Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If - Then Formula
Please Help!! I have column A as a drop down list and would like it if column C would give a corresponding price to what is picked in column A from the drop down list. Any quick fixes? Thanks A Bunch! -- kgeorge ------------------------------------------------------------------------ kgeorge's Profile: http://www.excelforum.com/member.php...o&userid=32804 View this thread: http://www.excelforum.com/showthread...hreadid=532065 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If - Then Formula
You make a table somewhere within your workbook (possibly expand on the source list for your drop down?) with your data that comprises your drop down list and in the adjacent column list the prices that are associated to each item in your list. Then use a VLOOKUP() formula in column C of the sheet containing your drop down. When an item is selected from your drop down the formula will display the associated price from your table. Something like: =VLOOKUP(cell holding the drop down,sheet name & range of your table,2,0) -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=532065 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If - Then Formula
Do you have a table of items & corresponding prices?
Let's say that range G1:G10 contains the labels for your drop down. In H1:H10 put the prices in C1 use: =vlookup(A1,$G$1:$h$10,2,false) "kgeorge" wrote: Please Help!! I have column A as a drop down list and would like it if column C would give a corresponding price to what is picked in column A from the drop down list. Any quick fixes? Thanks A Bunch! -- kgeorge ------------------------------------------------------------------------ kgeorge's Profile: http://www.excelforum.com/member.php...o&userid=32804 View this thread: http://www.excelforum.com/showthread...hreadid=532065 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |