Search and display the related category item names and rate in one cell

[skhari]

Hi Experts,

Please help me in getting the related sub category items and rate with reference to Master items from Sheet name(A1)
Kindly refer the attachment which i have highlighted(red) what I am expecting. Thank you for your time

[azumi]

Pls see the file attach, using array formula

Cheers

[skhari]

Wow! its a big formula. thank you. "Other items" sub categories are not getting displayed eg: TRGlass, Dinning table, switches. Please

[azumi]

I have my question, what logic that makes "Other Items" that makes results TRGlass, Dinning table, switches ? Im still confused man...

Azumi

[skhari]

Items which are NOT Equal to ReportDisplay! F4:F9 - will be added in Other items. Please refer G10 (formula differs from G9)

[azumi]

I make 2 version for Excel 2003 and 2007 (or later), and I hope you using 2007 because limitation of nested IF & ISERROR I can't hide the error with blanks results, but the results its okay.

Better if you use 2007, because you can add IFERROR to your situation more efficiently

Cheers

[skhari]

Thank you so much for your help. I am using 2007.
welldone!

[azumi]

Thanks for provide feedback


cheers