Posted by
Message
deeprig9
Georgia Fan
Member since Sep 2012
42257 posts

What's wrong with my VLOOKUP formula?
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?


DynaMike
Houston Astros Fan
Member since Aug 2015
765 posts

re: What's wrong with my VLOOKUP formula?
The table array has to include the whole table and the column number is what is returned
This post was edited on 1/6 at 1:25 pm


Replies (0)
Replies (0)
80
deNYEd
Kentucky Fan
Houston
Member since Jul 2007
9512 posts
 Online 

re: What's wrong with my VLOOKUP formula?
USE XLOOKUP!!!!


CAD703X
Toledo Fan
Liberty Island
Member since Jul 2008
67934 posts

re: What's wrong with my VLOOKUP formula?
its like the bat signal with you. do you have a notification setup when the keyword 'vlookup' shows up here?


deNYEd
Kentucky Fan
Houston
Member since Jul 2007
9512 posts
 Online 

re: What's wrong with my VLOOKUP formula?
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"


lsu02150
LSU Fan
BR
Member since May 2009
171 posts

re: What's wrong with my VLOOKUP formula?
=VLOOKUP(A2,Sheet1!A:B,2,FALSE)

or

=INDEX(Sheet1!B:B,MATCH(A2,Sheet1!A:A,0))


Replies (0)
Replies (0)
90
CAD703X
Toledo Fan
Liberty Island
Member since Jul 2008
67934 posts

re: What's wrong with my VLOOKUP formula?
quote:

bc I wager the house it contains "vlookup"
but would wager running backwards with a beer and a cigarette?


TD SponsorTD Fan
USA
Member since 2001
Thank you for supporting our sponsors
Advertisement
castorinho
Oklahoma Fan
13623 posts
Member since Nov 2010
73434 posts
 Online 

re: What's wrong with my VLOOKUP formula?
quote:

ts like the bat signal with you. do you have a notification setup when the keyword 'vlookup' shows up here?

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!

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


Replies (0)
Replies (0)
00
deNYEd
Kentucky Fan
Houston
Member since Jul 2007
9512 posts
 Online 

re: What's wrong with my VLOOKUP formula?
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.


TU Rob
Troy Fan
Birmingham
Member since Nov 2008
11177 posts

re: What's wrong with my VLOOKUP formula?
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.


ODP
Baylor Fan
Conroe
Member since Oct 2015
1226 posts

re: What's wrong with my VLOOKUP formula?
My company excel doesn't have xlookup, I want to try it so bad!


Replies (0)
Replies (0)
00
deNYEd
Kentucky Fan
Houston
Member since Jul 2007
9512 posts
 Online 

re: What's wrong with my VLOOKUP formula?
Sounds like you need a SUMIFS statement. First put in your sum range than you can have multiple criteria


Replies (0)
Replies (0)
00
tigercross
Member since Feb 2008
3567 posts

re: What's wrong with my VLOOKUP formula?
Get familiar with all of the powers of SUMPRODUCT. It does an amazing job of summarizing. This article is a good start:

LINK /


WhiskeyThrottle
Member since Nov 2017
2017 posts

re: What's wrong with my VLOOKUP formula?
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.


Replies (0)
Replies (0)
00
first pageprev pagePage 1 of 1next pagelast page
refresh

Back to top

logoFollow TigerDroppings for LSU Football News
Follow us on Twitter, Facebook and Instagram to get the latest updates on LSU Football and Recruiting.

FacebookTwitterInstagram