View in: Desktop
Copyright @2021 TigerDroppings.com. All rights reserved.
- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Coaching Changes
- 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
Posted by
Message
What's wrong with my VLOOKUP formula?Posted by deeprig9 
on 1/6/21 at 1:06 pm
on 1/6/21 at 1:06 pm
0
0I 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?
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"
TD Sponsor
TD Fan
USA
Member since 2001
TD FanUSA
Member since 2001
Thank you for supporting our sponsors Posted by Site Sponsor 
to Everyone
to EveryoneAdvertisement
re: What's wrong with my VLOOKUP formula?Posted by castorinho 
on 1/6/21 at 2:38 pm to CAD703X
on 1/6/21 at 2:38 pm to CAD703Xquote: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
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.
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.
re: What's wrong with my VLOOKUP formula?Posted by tigercross on 1/14/21 at 4:08 pm to TU Rob
Get familiar with all of the powers of SUMPRODUCT. It does an amazing job of summarizing. This article is a good start:
LINK /
LINK /
re: What's wrong with my VLOOKUP formula?Posted by WhiskeyThrottle 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
"Where the work gets done."
Popular
Back to top
Follow TigerDroppings for LSU Football News