Solved

LOOKUP formula

Posted on 2011-02-21
3
190 Views
Last Modified: 2012-05-11
Using Excel 2007.

I have two worksheets.  In each, Column A is 'name'.  

To populate Sheet 2 B2 I want to:
 - find the name text that is in Sheet2!A2 in Sheet1!A:A
 - return the corresponding text from Sheet1!B:B to Sheet2!B2

make any sense?
Thanks!
0
Comment
Question by:633535
3 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 34947326
Try using VLOOKUP, i.e. in sheet2 B2

=VLOOKUP(A2,Sheet1!A:B,2,0)

copied down column

regards, barry
0
 
LVL 33

Expert Comment

by:jppinto
ID: 34947329
Not sure what you're trying to do but it looks like a job for the VLOOKUP function! Here's how you can use VLOOKUP() function:

http://excel-user.blogspot.com/2009/10/vlookup-get-value-based-on-another.html

jppinto
0
 

Author Closing Comment

by:633535
ID: 34947510
Thanks - I knew it was VLOOKUP but hadn't configured it correctly.  Thanks!
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

831 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