Vlook up value with diffrent allocations

probably bet to use index and match.

can you upload a sample book for us to work on. it would make it easier

i would hazard a guess at something like this if this is the way you have listed your information.

but then again i dont know 100% (by the way this is an array formula and as such needs to be entered with Control+Shift+Enter not just Enter


Book1.xlsx

cool i was right here you go

Book1 (6).xlsx

ok if you wanna know how this works.

Please Login or Register  to view this content.

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

here is your book with it broken down a bit to help i hope

Book1 (6).xlsx