Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

# LOOKUP formula

Posted on 2011-02-21
Medium Priority
196 Views
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
Question by:633535
[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

LVL 50

Accepted Solution

barry houdini earned 2000 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

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

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

## Featured Post

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
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â€¦
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
###### Suggested Courses
Course of the Month7 days, 20 hours left to enroll