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
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.