Berry Metzger
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER