- 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
What's wrong with my VLOOKUP formula?
Posted on 1/6/21 at 1:06 pm
Posted on 1/6/21 at 1:06 pm
I want Sheet 2 Column B to display a value by looking at Sheet 2 Column A, looking for a match on Sheet 1 Column A, and returning the value of Sheet 1 column B. Exact match.
In sheet 2, I have this entered in B2.
=VLOOKUP(A2,Sheet1!A:A,2,FALSE)
What's wrong?
In sheet 2, I have this entered in B2.
=VLOOKUP(A2,Sheet1!A:A,2,FALSE)
What's wrong?
3
Posted on 1/6/21 at 1:22 pm to deeprig9
The table array has to include the whole table and the column number is what is returned
This post was edited on 1/6/21 at 1:25 pm
Posted on 1/6/21 at 1:27 pm to deeprig9
USE XLOOKUP!!!!
Posted on 1/6/21 at 1:29 pm to deNYEd
its like the bat signal with you. do you have a notification setup when the keyword 'vlookup' shows up here?Posted on 1/6/21 at 1:31 pm to CAD703X
quote:
its like the bat signal with you. do you have a notification setup when the keyword 'vlookup' shows up here?
I did chuckle at the thought of my xlookup promptness, but the world needs to know. I also enjoy clicking on every excel thread bc I wager the house it contains "vlookup"
Posted on 1/6/21 at 1:49 pm to deeprig9
=VLOOKUP(A2,Sheet1!A:B,2,FALSE)
or
=INDEX(Sheet1!B:B,MATCH(A2,Sheet1!A:A,0))
or
=INDEX(Sheet1!B:B,MATCH(A2,Sheet1!A:A,0))
Posted on 1/6/21 at 1:50 pm to deNYEd
quote:but would wager running backwards with a beer and a cigarette?
bc I wager the house it contains "vlookup"
Posted on 1/6/21 at 2:38 pm to CAD703X
quote:to be fair, it's such a game changer that I don't blame him. Saw it in one of his posts here and it changed my life!
ts like the bat signal with you. do you have a notification setup when the keyword 'vlookup' shows up here?
With that being said, vlookup is a tad faster for what the OP is trying to do here.
quote:
=VLOOKUP(A2,Sheet1!A:A,2,FALSE)
What's wrong?
Look at your array
Posted on 1/6/21 at 3:33 pm to CAD703X
quote:
but would wager running backwards with a beer and a cigarette?
prob not. I'm more of a lifter these days. Although, I had not run for 5 years before that bet. However, I have not run one stitch since that day either. I have another 40lbs as well. I believe I ended up with a grand total of $40 and a box of pop tarts from that wager. I would not do it again for less than 2k and even that gives me pause.
Posted on 1/13/21 at 2:34 pm to deNYEd
Trying to use some sort of lookup formula, but I'm not sure if I need a SUMIF statement, or if I can do it all with lookups. I have a large tab with line items split out by a set of 5 common names. My data runs from A87 down to AH803 on one tab, and on another tab I have those 5 common names across the top and the various expense lines going down the left side. I want to sum up the last 12 columns, W-AH, (months for 2021) if it is a match for Column A and Column B. Column A is a geographic description, and Column B is the expense line item. So I want to sum up if Column A is a certain geography, and if Column B is a certain expense. I could easily create a VLOOKUP on each row in my file, but thought there would be a way I could do it once and have it linked to what I want it to return from Columns A and B in the other tab.
Posted on 1/13/21 at 3:24 pm to deNYEd
My company excel doesn't have xlookup, I want to try it so bad!
Posted on 1/13/21 at 8:02 pm to TU Rob
Sounds like you need a SUMIFS statement. First put in your sum range than you can have multiple criteria
Posted on 1/15/21 at 9:49 am to tigercross
Haven't seen the sumproduct formula before. Will have to get familiar with that one.
I've since moved over to SQL Developer but I spent about 10 years building reporting with a handful of formulas. Countif(s), Sumif(s) and VLookup.
I've since moved over to SQL Developer but I spent about 10 years building reporting with a handful of formulas. Countif(s), Sumif(s) and VLookup.
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News