Clever Geek Handbook

Google Spreadsheet - fill row from dropdown

I am creating a Google Docs spreadsheet, its for my brothers construction company. To help him with quotes for potential jobs, he can gain control over expenses.

I have three sheets, Quote, Settings, Products.

The quote will contain the actual details. The settings will contain some static values ​​like VAT and the products will contain the actual value of the products ie Timber € 49.00, electrician € 250.00 etc.

I figured out how to create dropdowns containing an item ID from a product sheet, but when I select an item ID I want the entire row to be populated with details from a product sheet.

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

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

Any help was appreciated.

Hello,

+3


source to share


1 answer


The best way to display a series of data from another worksheet is to use the vlookup function. Details can be found at: http://anandexcels.wordpress.com/tag/vlookup-function-in-google-docs/



+3


source






More articles:


All Articles