Hi
As the title says, I have problem with INDEX MATCH COMBINATION
I have a database of item (A), quantity (B) and Code (C). Pls see the atachment
Now i want to find the Code (F) that looks up from item (E) and quantity is the greatest
I have been trying my best to make the index fomula return my expected value on F2
However i dont think i can do it on my own
So pls someone look at the case and suggest me how can i do it
Bookmarks