Indexing content in a right way

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