calling up cells from a table.

T

tanner

I'm trying to create a form that draws information from a table on a
seperate spreadsheet. This is an order form and the table carries the
product information....see below. What I need
is when the user selects a product and color, the adjacent cells in the
product table, with values and formulas, are copied to the form.

Item Color Quantity Weight Units/row
Paleo Beige 123 23.5lbs 42
Bergerac Grey 123 32 lbs 38

So if I have a drop down list on another sheet that chooses Paleo, then

the adjacent formulas and cells from the table would be copied over.


Maybe I should be doing this through a macro tied to a button.


Thanks again for your help.
 
A

Ardus Petus

=VLOOKUP(A1,Table:A1:E99,2,0) gets Color
=VLOOKUP(A1,Table:A1:E99,3,0) " Quantity
etc...

HTH
 
A

Ardus Petus

No: that will only copy the values.

To copy formulae, you need VBA code (macro)

HTH
 
P

Pete_UK

If Table is the sheet name, then you should really have:

=VLOOKUP(A1,Table!$A$1:$E$99,2,0) gets Color
=VLOOKUP(A1,Table!$A$1:$E$99,3,0) " Quantity

It can't copy the formula per se, only the value that the formula
produces - what formulae do you have anyway?.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copying adjacent cells with formula 4
Search for a value that repeats several times in another table 3
count cells in a table that meet multiple criteria 1
Access Passing the value to a table 1
Inserting a Copied Row inside a table 6
Help needed !! Look Up Table function ?? 6
Select a category from a list that populates related cells 1
How can I get excel to look up prices in a table 1

Top