[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Lookup function help in excel 2007

Posted on 2009-07-14
4
Medium Priority
?
162 Views
Last Modified: 2013-12-24
I have different invoice numbers in column A. I want to be able to match them up with a tracking number from another worksheet. The workbook would then show the invoice number in column A and the corresponding tracking number in column B
0
Comment
Question by:slo1215
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 3

Accepted Solution

by:
glenthorne earned 1500 total points
ID: 24850507
0
 
LVL 3

Assisted Solution

by:glenthorne
glenthorne earned 1500 total points
ID: 24850534
You will also need to link the two spreadsheets together
0
 

Author Comment

by:slo1215
ID: 24850927
Here are my 2 files. Test1 file2 and test1 file1.

I want file 2 to match column A with column C.
0
 

Author Comment

by:slo1215
ID: 24850957
Here are my 2 files. Test1 file2 and test1 file1.

I want file 2 to match column A with column C.
Test1-file2.xlsx
Test1-file1.xlsx
0

Featured Post

What’s Wrong with Your Cloud Strategy ?

Even as many CIOs are embracing a cloud-first strategy, the reality is that moving to the cloud is a lengthy process and the end-state is likely to be a blend of multiple clouds—public and private. Learn why multicloud solutions matter in this webinar by Nimble Storage.

Question has a verified solution.

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

Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

650 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