Help with Index Match or VLOOKUP

Closed
mwilke Posts 3 Registration date Wednesday October 26, 2016 Status Member Last seen March 21, 2017 - Mar 21, 2017 at 03:36 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Mar 21, 2017 at 04:10 PM
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 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Mar 21, 2017 at 04:10 PM
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
0