Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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?


See more

1 reply

Answer 1 / 1
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
Ask a question