Thread: [Solved] If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3)
View Single Post
 
Old 10-20-2014, 06:50 PM
lily lily is offline Windows 8 Office 2013
Novice
  
Join Date: Oct 2014
Posts: 18
lily is on a distinguished road
Default If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3)
Hi everyone, First of all thank you for helping me out. This is what I have

Sheet 1 - List of Description

C1 = Name (C2 to C20 )
D1 = Description (D2 to D20)
E1 = Price (E2 to E20)

fe. Watch (C2) Cartier Watch Design from 2009 (D2) 500,000 Dollar (E1)

Sheet 2 - Invoice

A10 - Here I would wanna refer to a cell in Sheet 1 - (C2 to C20)

Is it possible to automatically put the matching description and price in B10 and C10

Thank you
Reply With Quote