When I offered help, I had forgotten that you are the guy who is really
milking the list by not even bothering to try to determine the answer
yourself or doing any trial and error. All you do is ask many times in many
groups until you get someone to do your work for you. It seems to me that
you would be happier if you KNEW how to do something for yourself.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message news:...
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"stacia" wrote in message
...
In column A I have a cell which reads "Business Office"
below that I have an office number such as 883, 909, 911 etc
I subtotal at change in office number
On the second sheet I have the Business office title for each office
number
I need to find the name "Business Office", go down 4 rows to find office
number and match that to the table on sheet 2, return office name and
place
on the row below "Business Office"
I know I need to do a vlookup to sheet data $A$!:$G@45 and return the
business name.

Please help
--
Stacia