how to automatically insert names in a column for the coroesponding values in other column

[YOGESHP]

Hi
I need a formula design which will automatically fill blank column( marked as yellow) which correspondents to column value data (marked as blue) of sheet 1 and corresponding name of persons in data sheet 2...
for e.g. in sheet 1 i want result if value of E2 is 655001 in sheet 1, the formula will look for (the result needed at B2) in sheet 2 matching the value of E2 with A1 of sheet 2...and yeilding the result as "bhushan subhashsinh pardeshi" in B2... and for all rest blank column ( marked as yellow).. if value changes in column E of sheet 1 then blank column will get names coroesponding to values in sheet 2

[mehmetcik]

Paste into B2 then fill down.

=INDEX(Sheet3!B:B,MATCH(E2,Sheet3!A:A,0),0)

[YOGESHP]

thanks friend.. thanks a lot

[ariful.rbg]

We can also use simple VLOOKUP formula, e.g. =VLOOKUP(E2,Sheet3!A:C,3,0)