compare 2 columns and add stock numner

[steve111]

hi,

I have 2 sets of data in the attached file
what I would like to have is the stock number in column "g" also in column "e" were the materials are equal in column "h" and column " c"

the material repeats itself in column in column "c" as there are about 11000 lines yet in column "h" it will only be once as there are less lines

thanks for you help
steve

[FDibbins]

Please provide a regular excel workbook, not all members can open/access zip files (company fire walls etc). If the workbook is too big, remove all unnecessary data, and provide only enough data to show what you are trying to do

[steve111]

thank you
new reduced file attached
steve

[FDibbins]

Perhaps this in E2, copied down?
=INDEX($G$2:$G$10000,MATCH(C2,$H$2:$H$10000,0))

[steve111]

thank you , that was a great help to me

steve

[FDibbins]

Happy to help and thanks for the feedback

[sleepy777]

I have an almost similar issue. I hope someone could help.

Sheet1 contains (3 columns) Item Name, Stock Qty, Reorder Qty

I would like to generate/display/list in Sheet2 all rows from Sheet1 where Stock Qty IS lesser or equal to Reorder Qty (<=)

I hope you can help.

Thanks

[FDibbins]

Hi sleepy and welcome to the forum

I see you managed to post after all, but forum rules require you to start your own thread, not to ask your question on someone else's thread