Results 1 to 5 of 5

using Vlookup

Threaded View

  1. #1
    Registered User
    Join Date
    11-29-2007
    Posts
    3

    using Vlookup

    I have a work sheet in (2007 format) where the data is grouped by family type using "SUBTOTAL" option under the "Data" tab and in "Outline" option.

    I have another work sheet which works as front end where user will be entering some name and I need to get result to which family group does it belong to. I need to take the value that user enters in the frontend sheet and check in above worksheet and if value exists then return the family name.

    I have tried using Vlookup function but I am getting ouput as #N/A, since the data is grouped family type. I mean I am getting the result only for the first object in each group. i.e., If I have 3 objects in a particular family group then I am getting family name for 1st object in the group, but for other objects in that group its saying as #N/A.

    can anyone suggest me about how to get result for other items to in same group..
    Last edited by karteek72; 11-29-2007 at 12:59 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1