Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3) If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3)
Register FAQ Mark Forums Read

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-20-2014, 06:50 PM
lily lily is offline If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3) Windows 8 If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3) Office 2013
Novice
If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3) 		 
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
 

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Threaded Mode Threaded Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
VLOOKUP looking at another cell for its range Rich18144 Excel 1 06-24-2014 07:56 AM
Change formula cell range based on cell value Scoth Excel 4 10-25-2012 07:51 AM
If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3) show a cell s7y Excel Programming 26 05-26-2012 08:00 PM
If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3) Word VBA: Cannot Edit Range (Delete characters except the first in a table cell) tinfanide Word VBA 3 04-27-2012 09:48 AM
If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3) Limit cell range use talkinglens Excel 6 12-31-2010 08:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:09 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft