**Question description:**

*This user has given permission to use the problem statement for this blog.*

Hello ..!!!! i have Question regarding Excel Index & match Function.

Solved by O. C. in 60 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
11/05/2018 - 10:18

Welcome, Thanks for choosing Got It Pro-Excel.

User
11/05/2018 - 10:18

i have question regarding exce index & match function'

Excelchat Expert
11/05/2018 - 10:19

Okay.

Excelchat Expert
11/05/2018 - 10:19

What is the question please?

User
11/05/2018 - 10:21

i want to display the Price of the same item but at different occassions the Price was different

User
11/05/2018 - 10:22

how can do this using index & Match Function..?

User
11/05/2018 - 10:24

Out Put i want to be as er the table indicated

Excelchat Expert
11/05/2018 - 10:24

Okay. I have seen it.

Excelchat Expert
11/05/2018 - 10:24

Let me figure this out.

User
11/05/2018 - 10:25

but this table is small , so i could do it manually , but i have some huge table where i need formula to help me #

User
11/05/2018 - 10:25

thanks

Excelchat Expert
11/05/2018 - 10:27

Okay.

User
11/05/2018 - 10:34

any update..?

Excelchat Expert
11/05/2018 - 10:36

Almost please.

User
11/05/2018 - 10:36

thanks

Excelchat Expert
11/05/2018 - 10:53

The first formula is to return a list of unique Item names.

Excelchat Expert
11/05/2018 - 10:54

The formula is;

Excelchat Expert
11/05/2018 - 10:54

=INDEX($A$3:$A$13,MATCH(0,COUNTIF($D$7:D7,$A$3:$A$13),0))

User
11/05/2018 - 10:54

noted

Excelchat Expert
11/05/2018 - 10:55

Once we have the unique items list, will use it to find the different corresponding price values and put them in a row.

User
11/05/2018 - 10:55

can i have the formula for that..?

Excelchat Expert
11/05/2018 - 10:56

Just a moment as I tweak it please...

Excelchat Expert
11/05/2018 - 11:17

Thank you for your patience.

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*