Forum Discussion
Index and match function use
Appreciate if someone could help me understand the error. Index and Match functions are used for getting the data from the table 'A' as per the attached excel file in the link below. Trying to get ...
Thanks for your response. It works fine when B4, C4, D4, E4 is equal to 1, how can if B4 & C4 are equal to 0. In such a case, not able to get the code correctly. Appreciate any solution for this issue as well.
That is because your data are inconsistent: some are text, others are numbers:
In the attached version, ALL item codes have been converted to text. The formula is now the original one,