Organising data using Index and Match FUnction

[juhee]

I am stuck with respect to organising my data in excel using index and match. I tried using this function but am unable to get the results. The format of data is such that vlookup and hlookup are also not working.

I'll be very grateful to you if you could help me get around this problem.

I have attached the excel file with the raw data and the index match function that I'm using.

I look forward to hearing from you and do really appreciate your help.

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

[juhee]

The sample excel workbook is attached herewith

[AliGW]

Try this in column N and adapt it for the rest:

=LOOKUP(2,1/(($A$2:$A$30892=$L$4)*($B$2:$B$30892=$M$4)),$C$2:$C$30892)

[juhee]

Hey.... Many thanks.... it works... I'm very grateful to you for your kind help.... Thank you

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[wk9128]

Please select N4:R4 area, array formula