Previous Topic Next Topic

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

Answer 1 / 1
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

Similar discussions

Facebook id confirmation
Sonysahil -
HelpiOS -

1 response
Facebook says that my email doesn't match my facebook email
@@@@@@@@@@@ -
Ambucias -

1 response
Modern Warfare 2 online cant find matchs why
Roryyy -
dwebb -

162 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
Match partial text string in one sheet to another text string in another sheet
Santos -
Santos -

2 responses