The solution for displaying several different descriptions and codes of the same part numb

Hello Everyone,

I need your help to solve the problem that occurs to me in the excel table (attached).

In sheet Order, I have column A in which the part number is entered, in column E in sheet Artikli PN, when it finds a part number, it shows me the same part number in column B in sheet Order, but for the same part number there are the same or similar descriptions of parts, I also have the same problem in column C sheet Order, which should show me the code under which it is kept in the table Articles PN column A.
I need a solution, that by displaying the data in columns B and C of the Order sheet, there is an option to go to the next search or by typing enter, because as I mentioned, the same part number often has several codes and descriptions in columns A and B within sheeta Artikli PN

Thanks in advance for your help

TEST ORDERA.xlsx

Welcome to the forum.

Try in B2, copied down:

Formula:

Please Login or Register  to view this content.

Good luck!

Thank you very much Estevaoba

But unfortunately the formula doesn't work, it reports an error with brackets, I tried deleting the brackets, some minor changes, but I didn't manage to change the error (print screen attached)
Attachment 864532

I most likely did not explain or describe well how it should work.

By entering (40X8421) in cell A2 "Order", a search is performed in the cells of column E "Artikli PN" - by finding the same or similar value, for example in cell E2 (40X8421), the value from cell B2 (40X8421 Lexmark MKIT 200K) "Artikli PN" is copied in cell B2 "Order" and copied the value from cell A2 (7100670) "Artikli PN" in cell C2 "Order", if the overwritten value in cell C2 "Order" is not what I'm looking for, by clicking enter or using a command, continue the search is made to the next same or similar value, for example E3 (40X8421) "Artikli PN" and the values from cell E3 (40X8421) "Artikli PN" are copied into cell C2 "Order" and the value of cell B3 (RD 40X8421 Kmplt for different MS81x ) "Artikli PN" in cell B2 "Order"

I hope that I have at least managed to describe what the flow should be, if it is not possible to derive the formula, it is no problem

Thanks in advance

Try this then.

Formula:

Please Login or Register  to view this content.

Thank you very much DJunqueira,

Unfortunately, these formulas are not a solution either, the table behaves the same as with the original formula, I suppose that some serious VBA coding is still needed

Anyway, thank you for trying to help, at least I learned something new from you for future excel needs

Best regards and all the best