Search : in
By :

Referencing multiple Cells to one cell

Last answer on Jun 3, 2009 5:25:27 am BST Parish, on Jun 2, 2009 4:09:53 pm BST 
 Report this message to moderators

Hello,

I have a table of values that i have screenshott here, for you: http://i43.tinypic.com/123qq8l.jpg

I also have what resembles a query form, which i have screenshott for you, again: http://i41.tinypic.com/fon5uf.jpg

The person would simply alter the values under name / size / color on the query form, which would generate the "Product ID" (AAA in the screenshot), which would then generate the availability of the product (in the form of in or out of stock) as well as the price of said product.

So for example, if i was to edit:

Name / Size / Color
A / B / A

Then the Product ID would be automatically generated to ABA. And the availability of product ABA and it's cost would be generated.

or, if i was to;

Name / Size / Color
A / C / B

Then the Product ID would be automatically generated to ACB. And the availability of product ACB and it's cost would be generated.

Thanks for any help in advance.

Configuration: Windows XP
Firefox 3.0.10

Best answers for « Referencing multiple Cells to one cell » in :
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL + ; in the chosen cell. To insert current time, press CTRL+...
[VBA] Deleting a word in a range of cell Show[VBA] Deleting a word in a range of cell In the case you want to delete a word in a sentence, just create a small macro that removes the word. But it will become difficult when you have word like, for example, "Theword" or "THEWORD" or...
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
Download PDF-to-HTML Show
Download USA Unlisted Cell Phone Numbers ShowHas you friend flown for America without telling you where he/she would settle? Dont panic! USA Unlisted Cell Phone Numbers is a program which can help you. By using this program, you simply need to know his/her phone number in order to find...
Download Internet Cell Boost Show
Spreadsheet - Arithmetic expressions ShowIntroduction Arithmetic expressions are simple expressions built with arithmetic operators and constants or references to cells. Operands are the values upon which the operator acts. There are two types of arithmetic operators: Unary operators...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Ask your question Reply

1

 mubashir aziz, on Jun 3, 2009 5:25:27 am BST

Sorry my organization have blocked many sites and this http://i41.tinypic.com/fon5uf.jpg is also blocked. can't see what actually you require ......


Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran

   
Reply to mubashir aziz
Ask your question Reply
They need your help