Hi all
I was helped previosuly with this array formula:
What it does is look in 3 data sources and returns a unique list to the Summary sheet.
Please Login or Register to view this content.
I now need to add a 4th list to the above for the range H2:H316 on the sheet “Data 3”
How do I do this? I have tried without success
Paul
Hi,
I have uploaded an example as I know sometimes this helps explain what I need
In c5
=IFERROR(IFERROR(IFERROR(IFERROR(INDEX(Data!$O$6:$O$8, MATCH(0, COUNTIF($C$4:C4, Data!$O$6:$O$8), 0)), INDEX('Data 2'!$M$19:$M$20, MATCH(0, COUNTIF($C$4:C4, 'Data 2'!$M$19:$M$20), 0))),INDEX('Data 2'!$N$19:$N$20,MATCH(0,COUNTIF($C$4:C4,'Data 2'!$N$19:$N$20),0))),INDEX('Data 3'!$H$2:$H$316,MATCH(0,COUNTIF($C$4:C4,'Data 3'!$H$2:$H$316),0))),"")
Copy down
Array-entered of course!
Life's a spreadsheet, Excel!
Say thanks, Click *
Perfect - thank you ACE!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks