Hi,
I hope you guys can help me with a problem if have.
I have a code that looks up values in a separate excel file, this code works well (modified the location to the location
My problem is that sometimes there will be an extra row with the same lookup values, however my lookup code only shows one value and not the next one.
I would like to show both values with the same lookup values.
So if row 9 & row 10 have different values but the lookup values are the same I would like to see both values. ( in cells underneath each other)
Can somebody help me to adjust my code so it shows all the values.
Thank you so much for the help.
I hope you guys can help me with a problem if have.
I have a code that looks up values in a separate excel file, this code works well (modified the location to the location
VBA Code:
=IFERROR(INDEX('C:\Users\123\Desktop\Excel WIP\[Production Report.xlsm]Production Reports'!$D$2:$D$2002,MATCH(B16&C16,'C:\Users\123\Desktop\Excel WIP\[Production Report.xlsm]Production Reports'!$C$2:$C$2002&'C:\Users\123\Desktop\Excel WIP\[Production Report.xlsm]Production Reports'!$F$2:$F$2002,0)),"")
My problem is that sometimes there will be an extra row with the same lookup values, however my lookup code only shows one value and not the next one.
I would like to show both values with the same lookup values.
So if row 9 & row 10 have different values but the lookup values are the same I would like to see both values. ( in cells underneath each other)
Can somebody help me to adjust my code so it shows all the values.
Thank you so much for the help.