C
cybersteve
Hello - My question is: I have a spreadsheet with 2 worksheet pages.
Page 1 is a summary page where you click a drop down list of 10 part
items in column D and the price of the selected item is placed in cel
E2. The 2nd page has 2 columns which are the same 10 parts items lis
(B1:B10) - under Data > Validation its set as a list =TWIN. The othe
list (C1:C10) under Data > Validation is set as a list =TWIN_PRICING.
The price to go into E2 comes from column C. So, if someone selects o
page 1 - parts item 3 from the drop down list in Column D it equates t
the price on the 2nd page of Column C3. What is the correct formula t
match page 2 column B items to page 2 column C items, get that price
place it in E2 on page 1?? Thanks for your help !
Page 1 is a summary page where you click a drop down list of 10 part
items in column D and the price of the selected item is placed in cel
E2. The 2nd page has 2 columns which are the same 10 parts items lis
(B1:B10) - under Data > Validation its set as a list =TWIN. The othe
list (C1:C10) under Data > Validation is set as a list =TWIN_PRICING.
The price to go into E2 comes from column C. So, if someone selects o
page 1 - parts item 3 from the drop down list in Column D it equates t
the price on the 2nd page of Column C3. What is the correct formula t
match page 2 column B items to page 2 column C items, get that price
place it in E2 on page 1?? Thanks for your help !