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

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.
Berry MetzgerLean process improvement consultantAsked:
Who is Participating?
 
nutschConnect With a Mentor Commented:
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
 
Berry MetzgerLean process improvement consultantAuthor Commented:
Solution provided quickly was spot on to my needs.
0
All Courses

From novice to tech pro — start learning today.