Hi,
I have different item-numbers with recurring prefixs (21-*****, 11-*****, 32-***** etc.) in one column and a value assigned to that prefix in another.
I want to read the prefixes and divide another number based on the belonging value.
If item-number starts with the prefix then calculate divide number/value in range corresponding to prefix.
Is it a LOOKUP or array-formula I should use?
Bookmarks