All solutions INDEX Expert Solution – Excel INDEX Problems

Excel - INDEX Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc