using Vlookup

[karteek72]

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..

[NBVC]

Can you post your workbook (or representative sample) (zipped XL2003 or earlier file) showing intended results.

[karteek72]

here is th file

[NBVC]

Is this what you're looking for? (see attached)

[karteek72]

Yeh almost the same but not exactly....
thnx for ur help...