Forum Discussion
Solved
Index / Match with multiple possible results.
I have a database of part number, name, serial number and the same information for the part they are installed on. I'm using an Index / Match setup to pull specifics out of the database but I have o...
- I am using 365 and updated the original post with an example of the data I'm pulling against.
Thank you,
I am using 365 and updated the original post with an example of the data I'm pulling against.
Thank you,
Thank you,
=FILTER(Data!A:A,(Data!D:D=Query!$F$7)*(Data!B:B=Query!B8),"")
=FILTER(Data!C:C,(Data!D:D=Query!$F$7)*(Data!A:A=Query!E8),"")
- Thank you Hans... These equations work beautifully!!!