CODEWITHSUNDEEP
excel
Jiří Janák
Jiří Janák

Reputation: 11

Excel, 1 value contained in other column

I have list of IDs in A. B is column with date and it matches column A (every ID has its own date in B)

Column C contains some values from column A (some of those IDs).

Into column D, I need to find which IDs from C are contained also in A and write date from B into D to particular ID.

In other words, I have long list with IDs and dates and another list of IDs which some matches the first list. For those IDs which matches I need to get date information.

Hope it`s understandable, thank you very much :-)

Upvotes: 1

Views: 43

Answers (1)

Roberto Bonvallet
Roberto Bonvallet

Reputation: 33359

You have to use the VLOOKUP function. Write this in cell D1:

=VLOOKUP(C1, A:B, 2, FALSE)

C1 is the cell with the value you are looking for. A:B are the columns that contain the table in which you are searching. The 2 means that the result will come from the second column of that table (in this case, B) and the FALSE at the end is for requiring an exact match.

Upvotes: 3

Related Questions