- 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
Excel formula help
Posted on 6/26/17 at 10:17 am
Posted on 6/26/17 at 10:17 am
I'm trying to enter a formula that looks up the number in column a, then finds that number in column b on another sheet, and then returns the number in column e to column d on the original sheet
Would that be a vlookup? And can anyone help with the formula?
Many thanks
Would that be a vlookup? And can anyone help with the formula?
Many thanks
1
Posted on 6/26/17 at 10:44 am to Paige
Are Column B and E in the same sheet?
If so, a vlookup will work. Make sure column B is to the left of column E in your dataset. Also, column A and B need to be in the same format. (number, date, text, etc.)
If so, a vlookup will work. Make sure column B is to the left of column E in your dataset. Also, column A and B need to be in the same format. (number, date, text, etc.)
Posted on 6/26/17 at 10:52 am to seawolf06
Yes b and e are on the same sheet
They're in the same format
I still can't make it work. Not sure what I'm doing wrong
Ok I was entering one column wrong.
Thanks!
They're in the same format
I still can't make it work. Not sure what I'm doing wrong
Ok I was entering one column wrong.
Thanks!
This post was edited on 6/26/17 at 10:58 am
Posted on 6/28/17 at 3:07 pm to Paige
Any time.
Mrexcel.com is another great forum for excel and vba.
Mrexcel.com is another great forum for excel and vba.
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News