Home |
Search |
Today's Posts |
#1
|
|||
|
|||
value reference to a certain cell
I have created a table with some items of goods (A2:A6), proper unit of measures (B2:B6) and prices (C2:C6). Then I created a drilldown list of goods (A2:A6) thru VALIDATION function in cell E2. I would like UOM and PRICE in cells F2 and G2 to appear automatically like values in cells B2 and C2, i.e. I want UOM and PRICE referenced correctly while choosing any item of goods in cell E2. Appeciate your advice or help in giving a link to resolving the issue. Tks. +-------------------------------------------------------------------+ |Filename: e.g..jpg | |Download: http://www.excelforum.com/attachment.php?postid=3616 | +-------------------------------------------------------------------+ -- littleps ------------------------------------------------------------------------ littleps's Profile: http://www.excelforum.com/member.php...o&userid=25482 View this thread: http://www.excelforum.com/showthread...hreadid=389340 |
#2
|
|||
|
|||
Perhaps you want something like this:
http://www.officearticles.com/tutori...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com "littleps" wrote in message ... I have created a table with some items of goods (A2:A6), proper unit of measures (B2:B6) and prices (C2:C6). Then I created a drilldown list of goods (A2:A6) thru VALIDATION function in cell E2. I would like UOM and PRICE in cells F2 and G2 to appear automatically like values in cells B2 and C2, i.e. I want UOM and PRICE referenced correctly while choosing any item of goods in cell E2. Appeciate your advice or help in giving a link to resolving the issue. Tks. +-------------------------------------------------------------------+ |Filename: e.g..jpg | |Download: http://www.excelforum.com/attachment.php?postid=3616 | +-------------------------------------------------------------------+ -- littleps ------------------------------------------------------------------------ littleps's Profile: http://www.excelforum.com/member.php...o&userid=25482 View this thread: http://www.excelforum.com/showthread...hreadid=389340 |
#3
|
|||
|
|||
F2: =VLOOKUP($E2,A2:C6,2,False)
G2: =VLOOKUP($E2,A2:C6,3,False) -- HTH Bob Phillips "littleps" wrote in message ... I have created a table with some items of goods (A2:A6), proper unit of measures (B2:B6) and prices (C2:C6). Then I created a drilldown list of goods (A2:A6) thru VALIDATION function in cell E2. I would like UOM and PRICE in cells F2 and G2 to appear automatically like values in cells B2 and C2, i.e. I want UOM and PRICE referenced correctly while choosing any item of goods in cell E2. Appeciate your advice or help in giving a link to resolving the issue. Tks. +-------------------------------------------------------------------+ |Filename: e.g..jpg | |Download: http://www.excelforum.com/attachment.php?postid=3616 | +-------------------------------------------------------------------+ -- littleps ------------------------------------------------------------------------ littleps's Profile: http://www.excelforum.com/member.php...o&userid=25482 View this thread: http://www.excelforum.com/showthread...hreadid=389340 |
#4
|
|||
|
|||
Anne Troy and Bob Phillips, Your info is very helpful and understandable :) . Thank you for quick help. I am really happy that I've learnt some more about excel. Rgds....Pavel -- littleps ------------------------------------------------------------------------ littleps's Profile: http://www.excelforum.com/member.php...o&userid=25482 View this thread: http://www.excelforum.com/showthread...hreadid=389340 |
#5
|
|||
|
|||
Thanks for the feedback! We appreciate it. :)
******************* ~Anne Troy www.OfficeArticles.com "littleps" wrote in message ... Anne Troy and Bob Phillips, Your info is very helpful and understandable :) . Thank you for quick help. I am really happy that I've learnt some more about excel. Rgds....Pavel -- littleps ------------------------------------------------------------------------ littleps's Profile: http://www.excelforum.com/member.php...o&userid=25482 View this thread: http://www.excelforum.com/showthread...hreadid=389340 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Flexible Cell Reference | Excel Discussion (Misc queries) | |||
reference cell value from fixed column with variable row | Excel Discussion (Misc queries) | |||
Using a Text / Data output as a cell reference | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Using the results from two seperate cells to create cell reference | Excel Worksheet Functions |