Thread
:
vlookup I give up
View Single Post
#
4
Posted to microsoft.public.excel.misc
stacia
external usenet poster
Posts: 23
vlookup I give up
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
.
Reply With Quote
stacia
View Public Profile
Find all posts by stacia