ST Alpha - "Any of you guys excel wizards? " (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 158

Any of you guys excel wizards?

Posted by sweatshopking Aug 11 '23, 11:17

for my sweet first post i wanted to ask if you guys were excel geniuses. i am using vlookup to pull data from 2 columns into a third, but when i try the same thing on the same info a few columns later it doesn't work and i don't know why

this is the code that works
=VLOOKUP(C2,A:B,2,FALSE)

searches columns a:b for a match with c2 and then pulls the info from column 2 when there is a match.

=VLOOKUP(E2,A:B,1,FALSE)

this one doesn't work and idky. I thought it would search a:b for a match to e2 and then pull the info from column 1 (in this case A). however, it does not. instead it ruins my life and says #NA

if any of you geniuses had any idea i'd love it.

Responses:

I can't offer any help, but that was indeed a sweet first post -- nm - prayformojo 🐵 Aug 11, 11:47 9
- thanks - sweatshopking Aug 11, 11:51 1
  - It stands for "no message," a quick way of saying readers don't need to click the post. They've already read the whole message. -- nm - David Aug 11, 11:52
- i thought new signups were closed -- nm - hollywood big shot Aug 11, 11:50 3
  - He knows a guy - Pippy 🏳️‍🌈 aka lady on the plane Aug 11, 12:29
  - But how will I get the food chemicals I need to give my dishes flavour? -- nm - Roger More Aug 11, 11:53
  - I made a special exception -- nm - Beryllium Aug 11, 11:51
- sweet post from a sweat shop -- nm - mud Aug 11, 11:50 2
  - Maybe he's a sweetshopking -- nm - Beryllium Aug 11, 11:52 1
    - i made my handle while working at a sweatshop, not a sweetshop --nm -- nm - sweatshopking Aug 11, 11:53
Vlookup only matches off Column A, but then lets you pull (return) from whatever column you designate. - Will Hunting Aug 11, 11:38
VLOOKUP only works left to right. The lookup value has to be in the leftmost column and then you can pull matching data from columns to the right. -- (edited) - spamlet Aug 11, 11:28 4
- xlookup worked - sweatshopking Aug 11, 11:46 2
  - Wasn’t sure if you had access to that as it’s only the newest version (I don’t) but glad she helped -- nm - spamlet Aug 11, 11:50 1
    - thanks - sweatshopking Aug 11, 11:52
- 👆 this -- nm - oblique Aug 11, 11:33

Post a message top

Any of you guys excel wizards?

Replies are disabled on threads older than 7 days.