Cross Referencing Lists

R

Ralph

Hi,

I have 2 tables, table 1 has 2 colums of entries, let's say
columns A and B. Table 2 has only 1 column of entries.
Some (but not all) of Table 2's entries are also in column
B of table 1. In the cases where an entry found in table 2
matches an entry found in column B of table 1 I need Excel
to return the entry in COLUMN A



When
 
Top