Indexing content in a right way

%3CLINGO-SUB%20id%3D%22lingo-sub-2257556%22%20slang%3D%22en-US%22%3EIndexing%20content%20in%20a%20right%20way%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2257556%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20community!!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20two%20excel%20sheets%2C%20in%20one%20I%20have%20descriptions%20that%20correspond%20to%20different%20codes%20and%20in%20the%20other%20in%20the%20description%20it%20says%20%22No%20description%20in%20english%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhere%20it%20says%20%22No%20description%20in%20english%22%2C%20I%20should%20index%20the%20description%20of%20the%20second%20excel.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20descriptions%20should%20be%20indexed%20according%20to%20the%20right%20code.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20days%20trying%20to%20solve%20this%20with%20no%20success.%20I%20would%20highly%20apprecciate%20your%20support!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20attached%20an%20excel%20sheet%20so%20that%20it%20is%20more%20clear.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2257556%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hello community!! 

 

I have two excel sheets, in one I have descriptions that correspond to different codes and in the other in the description it says "No description in english"

 

Where it says "No description in english", I should index the description of the second excel. 

 

The descriptions should be indexed according to the right code. 

 

I have been days trying to solve this with no success. I would highly apprecciate your support! 

 

I attached an excel sheet so that it is more clear. 

 

Thank you!!!!

2 Replies

@jfrjfr 

 

You may try one of these formulas in D2 on first sheet...

=IF(C2="No description in english",IFERROR(INDEX(Hoja2!D:D,MATCH(B2,Hoja2!B:B,0)),""),C2)

OR

=IF(C2="No description in english",IFERROR(VLOOKUP(B2,Hoja2!B:D,3,0),""),C2)

and copy the formula down the rows.

@jfrjfr 

You may construct your formula in Hoja1!C2, like this:

Twifoo_0-1617763441756.png