software

I have a drop down list of different products that I sell and I want to
be able to click on one of those products in the drop down list and
then in the cost column of my spreadsheet I want it to insert the price
for that product from the drop down list. ANy help on how to do this
would be great, I trie V Lookup and IF then statments and I can't get
them to work.Thanks Scott--
badgrandntl
------------------------------------------------------------------------
badgrandntl's Profile: www.excelforum.com/member.php...oamp;userid=31035
View this thread: www.excelforum.com/showthread...hreadid=507020
Scott:
I'm fairly sure that VLOOKUP, used properly, will satisfy your request.
So, please post your formula(s) and we'll see what the forum can do for
you.

Regards,
Ron--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=507020
This is the formula for the first one:

VLOOKUP(Sheet2!A2,Sheet2!A42,1)

If this doesn't help I can email u the file.

Thanks very much for your help--
badgrandntl
------------------------------------------------------------------------
badgrandntl's Profile: www.excelforum.com/member.php...oamp;userid=31035
View this thread: www.excelforum.com/showthread...hreadid=507020Say your dropdown list is in A1 (and created via Data|Validation).

Then in B1, you could put a formula like:

=if(a1=quot;quot;,quot;quot;,vlookup(a1,sheet2!a:b,2,false))
badgrandntl wrote:
gt;
gt; I have a drop down list of different products that I sell and I want to
gt; be able to click on one of those products in the drop down list and
gt; then in the cost column of my spreadsheet I want it to insert the price
gt; for that product from the drop down list. ANy help on how to do this
gt; would be great, I trie V Lookup and IF then statments and I can't get
gt; them to work.
gt;
gt; Thanks Scott
gt;
gt; --
gt; badgrandntl
gt; ------------------------------------------------------------------------
gt; badgrandntl's Profile: www.excelforum.com/member.php...oamp;userid=31035
gt; View this thread: www.excelforum.com/showthread...hreadid=507020

--

Dave Peterson


Could part of my problem be that some of the suff in my list has 5quot;
Reynolds and I think the Parentheses could mess it up.

My first drop down list is : The information for this is on Sheet 2,
cells A1-A15
The drop down list is located on Sheet 1 cell A7 I want the price to go
into cell C7 on sheet 1.
5quot; GUTTER
5quot; REYNOLDS
5quot; REYNOLDS P/U
5quot; ROLLEX
5quot; ROLLEX P/U
5quot; ALSIDE
5quot; ALSIDE P/U
5quot; ALCOA
5quot; ALCOA P/U
5quot; COPPER
5quot; COPPER HR
5quot; QUALITY EDGE
5quot; QUALITY EDGE P/U
5quot; GALV HR
5quot; GALV

The price list for the above items is located on sheet 2, cells
A42-A56

0
1.15
1.10
1.15
1.10
1.20
1.15
1.23
1.18
6.75
6.75
1.23
1.23
2.20
2.40Thanks for the help I am still trying to learn this program, Thanks for
your time Scott--
badgrandntl
------------------------------------------------------------------------
badgrandntl's Profile: www.excelforum.com/member.php...oamp;userid=31035
View this thread: www.excelforum.com/showthread...hreadid=507020Create your table in sheet2:

A1:A15 should contain your parts
B1:B15 should contain the prices

Life will be a lot simpler if your table is laid out nicely.
badgrandntl wrote:
gt;
gt; Could part of my problem be that some of the suff in my list has 5quot;
gt; Reynolds and I think the Parentheses could mess it up.
gt;
gt; My first drop down list is : The information for this is on Sheet 2,
gt; cells A1-A15
gt; The drop down list is located on Sheet 1 cell A7 I want the price to go
gt; into cell C7 on sheet 1.
gt; 5quot; GUTTER
gt; 5quot; REYNOLDS
gt; 5quot; REYNOLDS P/U
gt; 5quot; ROLLEX
gt; 5quot; ROLLEX P/U
gt; 5quot; ALSIDE
gt; 5quot; ALSIDE P/U
gt; 5quot; ALCOA
gt; 5quot; ALCOA P/U
gt; 5quot; COPPER
gt; 5quot; COPPER HR
gt; 5quot; QUALITY EDGE
gt; 5quot; QUALITY EDGE P/U
gt; 5quot; GALV HR
gt; 5quot; GALV
gt;
gt; The price list for the above items is located on sheet 2, cells
gt; A42-A56
gt;
gt; 0
gt; 1.15
gt; 1.10
gt; 1.15
gt; 1.10
gt; 1.20
gt; 1.15
gt; 1.23
gt; 1.18
gt; 6.75
gt; 6.75
gt; 1.23
gt; 1.23
gt; 2.20
gt; 2.40
gt;
gt; Thanks for the help I am still trying to learn this program, Thanks for
gt; your time Scott
gt;
gt; --
gt; badgrandntl
gt; ------------------------------------------------------------------------
gt; badgrandntl's Profile: www.excelforum.com/member.php...oamp;userid=31035
gt; View this thread: www.excelforum.com/showthread...hreadid=507020

--

Dave Peterson


So what formula can I do to match this stuff up, I listed the correct
cells in my above post, Dave I will take your advice and move the stuff
it make more sense that way, but I just need it so when I selec the
product the price comes up.

Thanks Scott--
badgrandntl
------------------------------------------------------------------------
badgrandntl's Profile: www.excelforum.com/member.php...oamp;userid=31035
View this thread: www.excelforum.com/showthread...hreadid=507020
I will move the stuff so it is moe organized. I still can't get the
formulas to work to make the price pop up when the product is selected.
Withe the cells listed above could someonegive me a formula so I can
try that, Dave I tried the formula you gave but it didn't work. I can
email the excel document to u if it would make it easier.

Thanks Scott--
badgrandntl
------------------------------------------------------------------------
badgrandntl's Profile: www.excelforum.com/member.php...oamp;userid=31035
View this thread: www.excelforum.com/showthread...hreadid=507020After you get that table built, you can use the =vlookup() in the other post.

=if(a1=quot;quot;,quot;quot;,vlookup(a1,sheet2!a:b,2,false))
badgrandntl wrote:
gt;
gt; So what formula can I do to match this stuff up, I listed the correct
gt; cells in my above post, Dave I will take your advice and move the stuff
gt; it make more sense that way, but I just need it so when I selec the
gt; product the price comes up.
gt;
gt; Thanks Scott
gt;
gt; --
gt; badgrandntl
gt; ------------------------------------------------------------------------
gt; badgrandntl's Profile: www.excelforum.com/member.php...oamp;userid=31035
gt; View this thread: www.excelforum.com/showthread...hreadid=507020

--

Dave Peterson

How about a little more info.

Where is the cell with the dropdown list? A1, A99, B12....
Where is the cell with the formula? B1, B99, C12, ...

What's the sheet name with the table?

What's the address of the table on that sheet? A1:B99???

What formula did you try?
badgrandntl wrote:
gt;
gt; I will move the stuff so it is moe organized. I still can't get the
gt; formulas to work to make the price pop up when the product is selected.
gt; Withe the cells listed above could someonegive me a formula so I can
gt; try that, Dave I tried the formula you gave but it didn't work. I can
gt; email the excel document to u if it would make it easier.
gt;
gt; Thanks Scott
gt;
gt; --
gt; badgrandntl
gt; ------------------------------------------------------------------------
gt; badgrandntl's Profile: www.excelforum.com/member.php...oamp;userid=31035
gt; View this thread: www.excelforum.com/showthread...hreadid=507020

--

Dave Peterson