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 [‚ª] |
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... ;-) |
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... ;-) |
All times are GMT +1. The time now is 06:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com