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,
Which version of Excel do you have?
And could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- I am using 365 and updated the original post with an example of the data I'm pulling against.
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!!!