 Any Excel Experts out here??, Lookup Values |
Welcome Guest ( Log In | Click here to Register a free account now! )
Register a free account to unlock additional features at BleepingComputer.com
Welcome to Bleeping Computer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.  |
 Jun 2 2009, 09:43 AM
Post
#1
|
|
|
Member  Group: Members Posts: 23 Joined: 6-December 08 Member No.: 266,235  |
First sheet is "List" which contains columns of values which I want to reference. Column titles are GE, Description, PH. Next sheet has GE values in first row. I would like to search GE Values to return matching PH value in the next row. This should get me a raise!! Thanks, Jeff |
 |
 
|
|
Jun 16 2009, 07:11 PM
Post
#2
|
|
 Bleepin' Cynic Group: BC Advisor Posts: 10,440 Joined: 11-November 06 Member No.: 94,959 |
You can do this using the vlookup function.
-------------------- The power of accurate observation is commonly called cynicism by those who haven't got it.
—George Bernard Shaw |
|
|
|
|
Jun 19 2009, 06:21 PM
Post
#3
|
|
|
New Member Group: Members Posts: 10 Joined: 19-June 09 Member No.: 343,619 |
Or use Access!!!!!
|
|
|
|
|
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
| Lo-Fi Version | Time is now: 8th November 2009 - 01:25 AM |
© 2003-2009 All Rights Reserved Bleeping Computer LLC.