Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Return value in Col B, Table 1 using values in Table 2 , Col E that match Table 1, Col E

Posted on 2011-03-07
2
Medium Priority
?
332 Views
Last Modified: 2012-05-11
Return the value in Col B, Table 1 using values in Table 2 , Col E that match Table 1, Col E values.
Looking for a Non-VBA solution:

With two tables each with text values in Col E that can be identical in each Table (both tables sorted in ascending order by Col E),
 ... from Col B in Table 2 (located below Table 1 in the same columns), return the content of Table 1, Col B that matches Table 2, Col E.  

This is a left column lookup issue using values in Column E of  two tables to return from Col B.. VLOOKUP does not operate on left lookups, unfortunately.
Thanks in advance.
0
Comment
Question by:Berry Metzger
[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 Comments
 
LVL 39

Accepted Solution

by:
nutsch earned 1000 total points
ID: 35063196
Something like

=index(table1!$B$1:$B$100,match(E1,table1!$E$1:$E$100,0))

returns the value in table 1 column B that matches table 2 / e1 on the column E of table1.

Thomas

0
 

Author Closing Comment

by:Berry Metzger
ID: 35069101
Solution provided quickly was spot on to my needs.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

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.
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
Video by: Zack
Viewers will learn about using Excel in a browser with Excel Online.
Video by: Zack
Viewers will learn the basics of using Excel Tables, the benefits found with them, and some pitfalls.

715 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