Excel Lookup Problem

Hi all,

I've attached the file of my problem and my desired output.

I'll try and explain it the best I can, apologies.

On the left hand side we will have a list of customers, locations and IDs. The IDs are linked to a KPI, I'm looking for everything with a certain ID to the be populated on separate lines(as per the attachment)

Thanks so much in advance, i've spent so much time on this on Google and i cant find the answer.

Originally Posted by canapone

Ciao

in N4 to be copied across

=IFERROR(INDEX(A$2:A$5,AGGREGATE(15,6,ROW($2:$5)-1/(($C$2:$C$5=$H$2)+($C$2:$C$5=$H$3)),ROWS($1:1))),"")

Regards

Thanks so much this works really well!!!

N4=IF(N$3<>"",IFERROR(INDEX(A$2:A$5,AGGREGATE(15,6,ROW(A$2:A$5)-ROW(A$2)+1/(ISNUMBER(MATCH($C$2:$C$5,$H$2:$H$3,0))),ROWS($A$2:A2))),""),"")


Copy across and down

format column Q as date

Originally Posted by bebo021999

A bit shorter and error trap:

Please Login or Register  to view this content.

Thanks, that looks a bit easier to work with on my live example. I hope i can get it to work