Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if or lookup for facturations
i'm trying to find the wright formula for a facturations problem
i've got a pull down menu in my sheet, i want the next cell to show the price of the item i choose in the pull down menu exemple: i choose motor in cell a1 and i want to show the price in cell a2 please help... ;-) -- [‚ª] B|uTs [‚ª] |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if or lookup for facturations
One way:
Assume you have, on a second sheet (Sheet2) a table of items (column A) and prices (column B): B1: =VLOOKUP(A1,Sheet2!A:B, 2, FALSE) In article , BluTs wrote: i'm trying to find the wright formula for a facturations problem i've got a pull down menu in my sheet, i want the next cell to show the price of the item i choose in the pull down menu exemple: i choose motor in cell a1 and i want to show the price in cell a2 please help... ;-) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if or lookup for facturations
Use Data Validation for in-cell drop-down for selecting an item and VLOOKUP
for filling in the price. See Debra Dalgleish's site for more on VLOOKUP and Data Validation lists for entering the choices. http://www.contextures.on.ca/xlFunctions02.html http://www.contextures.on.ca/xlDataVal01.html Note the section on using DV lists from another worksheet by naming the list. Gord Dibben MS Excel MVP On Sat, 24 Feb 2007 19:48:10 -0800, BluTs wrote: i'm trying to find the wright formula for a facturations problem i've got a pull down menu in my sheet, i want the next cell to show the price of the item i choose in the pull down menu exemple: i choose motor in cell a1 and i want to show the price in cell a2 please help... ;-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Advanced Lookup (lookup for 2 values) | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) |