Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Drop down list question...
Here is one for you... I want to make a workbook with the following
ability. Pick an item from that drop down list in column "A" and it shows a price in column "B". I would assume I need a second sheet with the data paired up, but how do I set it up to pull said data to another sheet? |
#2
|
|||
|
|||
Hi!
You would use a lookup formula. Say your item list is in col A of sheet2. The price is in col B of sheet2. The total range size is A1:B50. Your dropdown is in A1 of sheet1 and you want the price to appear in B1: In B1 enter this formula: =IF(ISNA(VLOOKUP(A1,Sheet2!A1:B50,2,0)),"",VLOOKUP (A1,Sheet2!A1:B50,2,0)) The first part of the formula will cause cell B1 to remain blank if a match is not found. Biff -----Original Message----- Here is one for you... I want to make a workbook with the following ability. Pick an item from that drop down list in column "A" and it shows a price in column "B". I would assume I need a second sheet with the data paired up, but how do I set it up to pull said data to another sheet? . |
#3
|
|||
|
|||
Hi
see: http://www.contextures.com/xlDataVal01.html and http://www.contextures.com/xlFunctions02.html -- Regards Frank Kabel Frankfurt, Germany "GR" schrieb im Newsbeitrag news:fGcqd.225798$9b.182025@edtnps84... Here is one for you... I want to make a workbook with the following ability. Pick an item from that drop down list in column "A" and it shows a price in column "B". I would assume I need a second sheet with the data paired up, but how do I set it up to pull said data to another sheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down list question | Excel Discussion (Misc queries) | |||
How to change fonts in drop down list | Excel Discussion (Misc queries) | |||
formatting drop down list | Excel Discussion (Misc queries) | |||
Drop dow list complication | Excel Discussion (Misc queries) | |||
Drop List Referencing | Excel Worksheet Functions |