Help with Index Match or VLOOKUP

Closed
mwilke Posts 3 Registration date Wednesday 26 October 2016 Status Member Last seen 21 March 2017 - 21 Mar 2017 à 15:36
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 21 Mar 2017 à 16:10
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?


Related:

1 response

Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
21 Mar 2017 à 16:10
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