Automatically populating cells in a worksheet based on other worksheet column

Hi,

I have an excel sheet with two worksheets. Sheet 2 contains columns Date,Ticket Number,Team and Name. Sheet 1 contains columns Name and Team.

I want to create a formula wherein as soon as I enter the name in Sheet1 under column name, the system should fetch the team from the Sheet2 corresponding to the name and display the same under column Team in sheet1.

An early help in this regard will be highly appreciated. I am attaching the sample excel sheet.

Thanks

Hi,

I tried =IF(ISBLANK(VLOOKUP(Sheet1!A1,Sheet2!$C$1:$D$20,2,0)),"",VLOOKUP(A1,Sheet2!$C$1:$D$20,2,0)), But it did not yeild any results. Please see the sample sheet.

Thanks

Thanks... It helped.