Google Spreadsheet-从下拉项填充行 [英] Google Spreadsheet - populate row from drop down item

问题描述

我正在创建一个Google Docs电子表格，供我的兄弟建筑公司使用.它可以帮助他提供潜在工作的报价，这样他就可以控制成本.

I'm creating a Google Docs spreadsheet, its for my brothers construction company. Its to assist him with quotes for potential jobs, so he can get control of costs..

我有三页报价，设置和产品.

I have three sheets, Quote, Settings, Products.

报价将包含实际的逐项报价.设置将包含一些静态值，例如增值税，产品包含产品的实际成本，例如，木材49.00欧元，电工250.00欧元等.

Quote will contain the actual itemised quote. Settings will contain some static values like the VAT and Products contains the actual cost of products i.e Timber €49.00, Electrician €250.00 etc.

我已经弄清楚了如何创建包含产品表中商品代码的下拉框，但是当我选择商品代码时，我希望整个行都填充有产品表中的详细信息.

I've figured out how to create drop down boxes which contain the item code from the products sheet, but when I select the item code I want the entire row to be populated with the details from the products sheet.

以下是我到目前为止创建的内容的链接:

Here's a link to what I have created so far:

https://docs.google.com/spreadsheet/ccc?key=0AseLC0_NOCETdHRTV1Rlc3pGblEtTnBzQ1A2VDlEakE&usp=sharing

任何帮助表示赞赏.

此致

推荐答案

从另一张工作表中提取一行数据的最佳方法是使用vlookup函数.可以在以下位置找到详细信息: http://anandexcels.wordpress.com /tag/vlookup-function-in-google-docs/

The best way to pull a row of data from another sheet is to use the vlookup function. The details can be found at: http://anandexcels.wordpress.com/tag/vlookup-function-in-google-docs/

这篇关于Google Spreadsheet-从下拉项填充行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！