An Array VLOOKUP that returns a value from a random position

Hi.

Can someone please help me find a formula that would act as a vlookup but would look up and return a value even if it is not on the first position within the array. I have an SAP export that has on Column A the batch number and on column B the item description. The thing is that within the multiple batch number arrays it allocates on column B the item description only for one row and randomly (sometimes first, last or in the middle).


Thanks for your help and for taking the time to read my post.


All the best

hope it more clear with example

azumi

Hello,

Thank you very much for your help!
Can you also help me fill the fields with the formula such as in the attached file?

addit.xlsx

Thank you

George

I'm used formula from Mika, perfect for your needs pls check the file

Azumi

Thank you all very much for your help.

All the best!