filling missed items based on matching column between two sheets

[ABDELFATTA]

Hello
the result should be in column B for sheet REPORT based on matching column C with sheet stock , if the items are matched between two sheets based on column C , then should filling column B in sheet report based on matching with column B for sheet STOCK for each item in column C as I put result in column G , there is case if there is item in sheet report and is not existed in sheet stock when fill then should keep empty cell .

[kvsrinivasamurthy]

Macro not required. Formula will do.
In J2 than copied down

Please Login or Register  to view this content.

[ABDELFATTA]

Macro not required

why not ?
anyway thanks