Hi,


Try this in B2 and drag right to B4

=VLOOKUP($A2,Sheet2!$A$2:$D$20,COLUMN(B2),FALSE)

change the range A2 - D20 to suit

Mike
"ej" wrote:

I have this data in sheet 2

Name Addresss Telephone Designation
Vinita Balan International City 213 EMBA
Arunita Paul International City 210 GMBA
Katherine Paras Al Wasl 212 GMBA
I have sheet 1 with this information

Name Addresss Telephone Designation

What I want is when I type the name on sheet1 A2 - B2 to B4 will
automatically show up or a window will pop up will all the data found under
this name like the one in access?

Please help.