VBA : matching particular columns in two different sheets and return the result in another sheet

[Mounikarao]

Hello all, I have 3 Excel Sheets, I want to compare Column E with respect to input given by the user( from B in sheet1 ) in sheet 1 with column B in sheet2 and if matching the values then return the result of column A of sheet2 in sheet3 column D

Please reply me anyone ASAP i would be really thankful

 

[Fluff]

Duplicate to: VBA Excel sheet Columns

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.