If Sheet 1 Match Sheet 2

[nitesh2009]

Hi

I have a question.
I have data in sheet 1 (C2 COLUMN) IN ENGLISH, AND IN SHEET 2 ENGLISH (COLUMN B2) AND CHINESE (COLUMN A2).
I want to match the english from sheet 1 to sheet 2 if its correct then the chinese will appear in sheet 1 B2.

Can you help me.

Thanks Nitesh

 

[JoeMo]

Welcome to the forum!

In B2 of sheet1 and copy down (after changing the range addresses shown in red to cover all the data in sheet2):

=IFERROR(INDEX(Sheet2!$A$2:$B$10,MATCH(Sheet1!C2,Sheet2!$B$2:$B$10,0),1),"")

 

[Trebor76]

Hi nitesh2009,

Welcome to MrExcel!!

If I've understood correctly, (big If here) this formula in cell B2 of Sheet1 should do the job:

=INDEX(Sheet2!A:A,MATCH(C2,Sheet2!B:B,0))

Regards,

Robert

 

[My Aswer Is This]

I do not understand this.
You said:

I have data in sheet 1 (C2 COLUMN)

Excel has no C2 Column

Do you mean Column C ?

Or do you mean Range("C2") ?


Excel has columns like A B C D E


​

 

[nitesh2009]

Hi Robert

I tried but it doesnt work. if you can email me then i can send the sheet so that you can help me nitesh2009@163.com

 

[nitesh2009]

i mean the column C. I have data In COLUMN A (CHINESE) & IN COLUMN B (ENGLISH) IN SHEET 2, I want to match in SHEET 1 COLUMN C which is in english to enter the chinese (automatically if matches in column C english from SHeet 2 to sheet 1)

 

[Trebor76]

Hi Robert

I tried but it doesnt work. if you can email me then i can send the sheet so that you can help me nitesh2009@163.com

Strange, it worked for me I don't give out my email address I'm afraid.

When you say it doesn't work - what happened? If #N/A was returned that's because an exact match wasn't found.

 

[nitesh2009]

Yes #N/A was returned, But in some row it came but not all of them as i have multiple same entries. but it showed in only few of them

 

[Trebor76]

The formula will show the results for the first match. If there are multiple matches I think you'll need an array formula but I'm no expert as those though I'm sure someone on this forum will be