search cell
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: search cell

  1. #1
    Guest

    Default

     
    ok, another issue. I have my data on worksheet3 with names, numbers, units,etc as columns. I have a cell on sheet 1 that I want to input the unit number. I want all the matching units and the other rows that coincide with those found to be display in an area on the sheet1. I orginal did it through get external data and ran a msquery from sheet3(which was really internal). It works on my computer but when emailed, the link to the external data(which is really internal) in wrong thus it doesnt work. any help would be appreiciated.

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Try vlookup. I've got several posts that describe them. Do a search.


    ~Anne Troy

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com