Hello
I need a lookup and return on Mon Scrap Sheet in col a and b, It needs to return the MC in col c and the part number in d.
it has to be smart enough so it groups with no spaces, as to the expected data in yellow, green, and red
cheers
Hello
I need a lookup and return on Mon Scrap Sheet in col a and b, It needs to return the MC in col c and the part number in d.
it has to be smart enough so it groups with no spaces, as to the expected data in yellow, green, and red
cheers
Try at A12
=IFERROR(INDEX(Sheet2!C$1:C$150,AGGREGATE(15,6,ROW(Sheet2!$D$4:$D$150)/(Sheet2!$D$4:$D$150<>""),ROWS(A$12:A12))),"")
FANTASIC Bo_Ry, thanks for your time and effort
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks