Hi Kmclean,
I am no excel pro by any measure, I have probably taken a very long way around a short solution but hey, its how my learning brain works.
I also couldn't get it to work with your original table setup, sorry about that.
Have a look at the attached, I think it works
In L4
=INDEX('PRL1A PRL2A PART NUMBER DATA'!$H:$H, MATCH($A$3&$B$3&$C$3&$D$3&$E$3&$F$3&$G$3,'PRL1A PRL2A PART NUMBER DATA'!$A:$A&$B:$B&$C:$C&$D:$D&$E:$E&$F:$F&$G:$G,0))
In M4
=INDEX('PRL1A PRL2A PART NUMBER DATA'!$I:$I,MATCH($A$3&$B$3&$C$3&$D$3&$E$3&$F$3&$G$3,'PRL1A PRL2A PART NUMBER DATA'!$A:$A&$B:$B&$C:$C&$D:$D&$E:$E&$F:$F&$G:$G,0))
In N4
=IF($H$3="SURFACE",INDEX('PRL1A PRL2A PART NUMBER DATA'!$J:$J,MATCH($A$3&$B$3&$C$3&$D$3&$E$3&$F$3&$G$3,'PRL1A PRL2A PART NUMBER DATA'!$A:$A&$B:$B&$C:$C&$D:$D&$E:$E&$F:$F&$G:$G, 0)),INDEX('PRL1A PRL2A PART NUMBER DATA'!$K:$K,MATCH(A3&B3&C3&D3&E3&F3&G3,'PRL1A PRL2A PART NUMBER DATA'!$A:$A&$B:$B&$C:$C&$D:$D&$E:$E&$F:$F&$G:$G,0)))
Bookmarks