ok if you wanna know how this works.
firstly you set up what field you want to index (in this case the dimension part
(in this case C2:C10)
then you get it to find where a match occours (its an array formula do to the ract that you have to add 2 cells togther (i put a bit extra in incase words overlap)
so match(A1&"||"&B1,
means match(EMP_01||Dimension 1
then you set up where it seaches so by adding the to feilds again you create a list of results
then excel picks the exact match and returns that row and the index uses that to give you an answer
im not sure how clear that is but i hope it helps a bit
Bookmarks