Lookup (?)

Topic

New Reply

I have a master list of contract numbers in column A (>500). In column B, I have listed the names that correspond to the contracts in column A. In column C, I have a list of the contracts utilized during any given month (<100), which is a subset of the list in column A. What I would like to do is in column D, list the names of the contracts that were utilized during the month. Any ideas?
Thanks in advance.

Reply | Quote

Replies

Something like this in D2:
=VLOOKUP(C2,A:B,2,0)

Copy it down the column

Steve

Reply | Quote

Thanks Steve.

Reply | Quote