Dear All

I have item codes in the Column "A" and the item Names in the Column "B" and Detail of items in the Column "C".

On one side of these column If I enter ITEM NAME ITS ITEM CODE AND DETAILS SHOULD BE APPEARED IN COLUMN "E" TO ONWARD.

KAHN-cann

• Moved by Lanlan HuangMicrosoft contingent staff Thursday, May 07, 2015 6:32 AM

Hello,

Maybe like in this screenshot. The formula in cell E2 is

=INDEX(A:A,MATCH(D2,B:B,0))

The formula in D2 is

=INDEX(C:C,MATCH(D2,B:B,0))