I have some products with dirfferent code , descriptions and prices. How can i format these item automatically
Answer:
What you need is making two sheets, one with the whole products with thier description and price (With Code as first column).
- Assume you have it in Sheet1 in range B3:J20 with columns Code, Description, Price, Qty, etc
- And the second sheet (Sheet2) will have these cells
- B2 will have you tio enter the product code in
- C1 will have you to enter the name of the column you want to show..
- C2 will show the product description (If C1 have the description column name in it)
- Now in C2 type this formula
=vlookup( b2, sheet1!B3:J20, match( C1, sheet1!b3:j3, 0) , false)
from now on changing the cells C1 and/or B2 will show you that column of that row
good luck
Read my profile, I am XLMan
You need to use the VLOOKUP function which searches for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify in the table. Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data you want to find.
The V in VLOOKUP stands for "Vertical."
Syntax:
VLOOKUP( lookup_value, table_array, col_index_num, range_lookup)
As soon as your products arrive and you start to list them simply assign them to a category . Say for example, items that are used for cleaning put them in that category with their information and code.
Do this with all your products and when ever you want to list a new product click on that category and only those items will appear. also don't forget to remove them from your inventory as you sell them. your computer can be set up for that also to remove them automatically.
Hi, perhaps you can try Google adwords to market your service/product.
Google adwords is a text-based system for advertising on its site and its partner sites. The service allows you to create your own ads, choose keywords to help match your ads to your audience, and control the cost of your advertising—you pay only when people click on your ad (a cost per click plan). Anyone wishing to promote a product on Google can enroll in this program.
you can get a 5 detail pages information about Google adwords at :
http://www.adcenter.net.cn/google-adword.
Good Luck && Best Wishes!
The answers post by the user, for information only, BAnswer.com does not guarantee the right.
Other Questions and Answers: