?
Solved

Excel cell link to another worksheet by using search

Posted on 2011-05-10
3
Medium Priority
?
177 Views
Last Modified: 2012-05-11
Dear Experts:
I would like to know how to get value from annother worksheet's cell.
I have one worksheet1 with all coupon code and customer name.
I also have worksheet2 with all coupon code and discount price.
How do I create a third column "Discount price" in worksheet1 and get the right discount price by linking to the
"discount price" in worksheet2.
Thanks,
Charlie
0
Comment
Question by:chencharlie1
  • 2
3 Comments
 
LVL 12

Accepted Solution

by:
sstampf earned 2000 total points
ID: 35729763
You need to use vlookup formula. See the following tutorials:
http://www.youtube.com/watch?v=2wHtcct7mCE (video)
http://www.techonthenet.com/excel/formulas/vlookup.php

Or do a google search.
0
 
LVL 12

Assisted Solution

by:sstampf
sstampf earned 2000 total points
ID: 35729814
0
 

Author Closing Comment

by:chencharlie1
ID: 35760181
Thanks
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question