The formula is in cell B2 and down.
I use column A as reference and want to find the same component i column D and get the corresponding item number in column E written into column B as illustrated in the attached file. I have tried with if, vlookup, offset, indeks and match but with no success. I know this should be entered as some sort of array function and have therefore also tried sumproduct and have a feeling that the solution lies with this function, but I have turned dry and need some input. Anyone?
Bookmarks