If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
vlookup I give up
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 |
#2
|
|||
|
|||
vlookup I give up
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 |
#3
|
|||
|
|||
vlookup I give up
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 . |
Thread Tools | |
Display Modes | |
|
|