#2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,522
Default vlookup I give up

This requires a VERY simple VLOOKUP. Perhaps a trip to the help index for
VLOOKUP would be helpful.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
vlookup I give up stacia Excel Discussion (Misc queries) 3 February 25th 10 07:15 PM
How can I have a false Vlookup give a blank instead of #N/A? TQCON Excel Worksheet Functions 2 August 14th 08 10:26 PM
vlookup does not give the result in the cell even though it is kbee Excel Worksheet Functions 2 February 15th 08 09:45 AM
What can I add to a vlookup formula to give me a 0 not #n/a Casper Excel Worksheet Functions 4 July 5th 05 05:32 AM
please give me an example of vlookup Garth Excel Worksheet Functions 3 May 27th 05 01:42 PM


All times are GMT +1. The time now is 12:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"