Index Match not working

[Shabbo]

Dear Sir,
Can you please check why index and match is not working in this case.

 

[herofox]

hello, you can to use like this

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

 

[Shabbo]

hello, you can to use like this

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

Dear Sir,
I want party name from sheet2 column C.

 

[vletm]

Shabbo
An answer to Your question:

Syntax
MATCH(lookup_value, lookup_array, [match_type])
The MATCH function syntax has the following arguments:

• lookup_value Required. The value that you want to match in lookup_array. For example, when you look up someone's number in a telephone book, you are using the person's name as the lookup value, but the telephone number is the value you want.
  The lookup_value argument can be a value (number, text, or logical value) or a cell reference to a number, text, or logical value.

 

[Shabbo]

Dear Sir,
Thanks for your reply, I tried the way you explained the match formula but still its not working.

 

[pecoflyer]

Try =INDEX(Sheet2!$C$2:$C$26,MATCH(Sheet1!$B2,Sheet2!$B$2:$B$26,0))
Adapt range as needed, do NOT use entire columns reference, it is bad practice !

 

[Ateeb Ali]

check attached file, formula working fine

 

[Ateeb Ali]

Also can try
=INDEX(Sheet2!C:C,MATCH($B2,Sheet2!B:B,0))

 

[pecoflyer]

You keep writing " it is not working" . please explain and add expected results manually in your example

 

[Ateeb Ali]

I have even attached file, you can open this and can check, its working fine