Thread: Is there a formula that I can use that will give the row data?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
EJ EJ is offline
external usenet poster
  
Posts: 20
Default Is there a formula that I can use that will give the row data?
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.
Reply With QuoteReply With Quote