i have excel file with 2 sheets, one sheet contents my items, prices, codes ,etc. the other sheet is to do cross matching with competitors. i've included an excel file and image to make my question as simple and clear.
i want to be able to generate my code automatically when manually entering any of my competitors codes. i was able to do index match but i was able to match with one column only as following (i'm assuming they all in one sheet to make it easier: =INDEX(C:C,MATCH(K2,E:E,0))
so this is looking only in E:E, when tried to enter different column such as C:C or D:D, etc. it returns error always.
tried to do the match as C:G but it gave error right away!
can anyone help please? would greatly appreciate.