Help with Index Match or VLOOKUP [Closed]

Report
Posts
3
Registration date
Wednesday October 26, 2016
Status
Member
Last seen
March 21, 2017
-
Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
-
Hello,

I have a worksheet with about 2000 rows. In column C and Column J i have a common Key. In Column K I have data that i want to write to Column E if there is a match in Column C and J.

Here is the problem. Column C and Column J are not aligned and there are way more words in Column J than in C.

Is there a formula that i can write that will for every instance of column C.... loop through Column J and when it finds a match then write that rows Column K to the row in column E beside the word in Column C we just looped through to find?


1 reply

Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
136
mwilke, Good afternoon.

Try to use:

E2 --> =IFERROR(VLOOKUP(C2, $J$2:$K$21, 2, FALSE),"")

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão