View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Adyna Adyna is offline
external usenet poster
 
Posts: 2
Default bring info from one sheet to another sheet

I need to find out if there is a way to do this:

Sheet 1:

COL A COL B
item 1 price 1
item 2 price 2
item 3 price 3

Sheet 2: (recipie)

COL A COL B
any item brought from Sheet 1 price of corresponding item


HOW DO I GET the price stored on COL B (sheet 1) to show on COL B (Sheet 2)
once the item (COL A) is selected?

Any ideas?

Thanks a million,