value reference to a certain cell

  • Thread starter Thread starter littleps
  • Start date Start date
L

littleps

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 |
+-------------------------------------------------------------------+
 
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
 
Back
Top