- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Can excel do this?
Posted on 11/18/14 at 8:16 am
Posted on 11/18/14 at 8:16 am
I have two reports. One of them has to be run monthly and there is no field available to pull from for the description. It just identifies each item by its code
The other report lists the name/description of each code
I'd like to add a column to the first report that contains the description or name for each code. So it needs to reference the second spreadsheet and find the name for each code
Probably doesn't make sense. But I'm pretty sure I've done something similar before
The other report lists the name/description of each code
I'd like to add a column to the first report that contains the description or name for each code. So it needs to reference the second spreadsheet and find the name for each code
Probably doesn't make sense. But I'm pretty sure I've done something similar before
9
Posted on 11/18/14 at 8:17 am to Paige
Yes
Posted on 11/18/14 at 8:17 am to Paige
yes
do you know VBA?
vlookup
do you know VBA?
vlookup
This post was edited on 11/18/14 at 8:18 am
Posted on 11/18/14 at 8:18 am to Paige
There isn't much you can't do with Excel. The hard part is just trying to figure out how the hell to do it 
Posted on 11/18/14 at 8:20 am to ForeverLSU02
quote:Troof
There isn't much you can't do with Excel. The hard part is just trying to figure out how the hell to do it
Posted on 11/18/14 at 8:21 am to Paige
If you can put the second spreadsheet on a separate sheet within the same file it will be easy with the vlookup command. Check out a YouTube tutorial on vlookup
Posted on 11/18/14 at 8:21 am to Paige
Vlookup should handle it.
On report A, you'd enter the code and vlookup formula in the next column would return the matching description from second spreadsheet, which I would copy onto a tab in reports A's spreadsheet.
On report A, you'd enter the code and vlookup formula in the next column would return the matching description from second spreadsheet, which I would copy onto a tab in reports A's spreadsheet.
Posted on 11/18/14 at 8:23 am to Paige
Why don't you just blow a guy that knows how to do this and he can do it for you?
Posted on 11/18/14 at 8:25 am to Bullfrog
yea, a simple vLookup should do it for you.
Unfortunately one does not simply explain how to do a vLookup.
Unfortunately one does not simply explain how to do a vLookup.
Posted on 11/18/14 at 8:26 am to Paige
quote:
Probably doesn't make sense. But I'm pretty sure I've done something similar before
Very easily. If they aren't in order you will need a vlookup or write your own vba routine. If they're in order then it's a simple sheet reference. = sheetname.cellref
Posted on 11/18/14 at 8:29 am to mikelbr
Would you be willing to do this for a blow job?
Posted on 11/18/14 at 8:32 am to TigerFanatic99
quote:
Unfortunately one does not simply explain how to do a vLookup.
Can't you just
Insert Function
Vlookup
and let Excel tell you exactly what to do?
It's just a matter of highlighting and selecting after that, isn't it?
Posted on 11/18/14 at 8:36 am to SSpaniel
not completely
Posted on 11/18/14 at 8:36 am to Paige
A basic macro could do this
Posted on 11/18/14 at 8:37 am to Paige
Oh my
Posted on 11/18/14 at 8:37 am to SSpaniel
Two more questions
Sometimes the well name changes, would the spreadsheet automatically update those fields? The code stays the same
What's the easiest way to report subsequent months? Just run the report for that month and copy and paste to the first report?
Sometimes the well name changes, would the spreadsheet automatically update those fields? The code stays the same
What's the easiest way to report subsequent months? Just run the report for that month and copy and paste to the first report?
Posted on 11/18/14 at 8:39 am to DirtyMikeandtheBoys
quote:
Why don't you just blow a guy that knows how to do this and he can do it for you?
As the sample population of this set is an integer greater than say, five, the prospects are fairly likely that she has already done so. She merely neglected to ask at the appropriate time. (It's "before" for the record)
Posted on 11/18/14 at 8:43 am to CaptainPanic
Would you do it for a blow job?
ok since it's possible I'll just send it to a broker
ok since it's possible I'll just send it to a broker
Posted on 11/18/14 at 8:52 am to Paige
I'd solve all of your excel woes for a long hug.
Posted on 11/18/14 at 8:52 am to Paige
quote:
Would you do it for a blow job?
sure
Page 1 of 2
Popular
Back to top
Follow TigerDroppings for LSU Football News