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

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

Below is the message I received from Don...then asking for $100.
I have tried many different vlookup options with none that work quite
correctly.


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.

--
Stacia


"Don Guillett" wrote:

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

.

This is his next response:

Then, perhaps you should pursue other employment opportunities or get
professional Excel help.

Don Guillett
Microsoft MVP Excel
SalesAid Software


--
Stacia


"Don Guillett" wrote:

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

.