Update on original Query

[SterlingSilver67]

Hello everyone, (this was asked 5/23 around 11 pm and responded to by Sam Capricii)


I'm tryin to make a workbook that will report multiple valued "attached" to multiple criteria.

On Sheet "Explaination" there is a an ID # - 10001A

On Sheet "Data" is the following columns (Batch, Type, Description)?

Formula: =xlookup -gives me what I want since I need that value - output: L-01

Is there a way to have values the values "L-02 - L-06" brought in as well if EXCEL notices that the value of L-01 is a duplicate and gives the next value?

Need "Types" brought in by batch No and not bring in additional values if not correlated with batch.


Sam Capricii helped me yesterday with the following =IFERROR(INDEX($C$1:$C$12,AGGREGATE(15,6,ROW($A$1:$A$12)/($A$1:$A$12=A$2),ROWS($A$1:A1))-(1-1),COLUMN()-(COLUMN()-1),1),"") - which worked perfectly with the information I provided (didn't provide enough). This was a huge benefit and sent me in the right direction by given me all values referenced by value.

I did not let them know that the Batch No will keep changing.

Thanks,

H

[AliGW]

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...eferenced.html