Random Thoughts 18: The Year of Fire

Status
Not open for further replies.

ClonerJams

Well-Known Member
SuperFanatic
SuperFanatic T2
Sep 26, 2022
7,126
16,153
113
I started a new job earlier this year. Today one of my younger counterparts is trying to show me how to use vlookup on excel. They are probably telling their friends how this old guy cant figure out basic excel functions right now.
 

BoxsterCy

Moderator
Staff member
Sep 14, 2009
48,318
47,234
113
Minnesota
Four days till Airventure. My motivation is plummeting.

Thought about that today. Heard a propeller aircraft. Something big but couldn't spy it through the tree cover and clouds. Sounded like big ass radials and not air guard transports. Usual summer air show at Flying Cloud Airport was cancelled for 2024. Boo that.
 

CycloneDaddy

Well-Known Member
Sep 24, 2006
8,378
7,814
113
Johnston
I started a new job earlier this year. Today one of my younger counterparts is trying to show me how to use vlookup on excel. They are probably telling their friends how this old guy cant figure out basic excel functions right now.
Learn the Index Match formula and throw it in their face.

=index(a:a,match(b1,c:c,0),1)
 

SaraV

Moderator
Staff member
Mar 13, 2012
8,717
9,604
113
I started a new job earlier this year. Today one of my younger counterparts is trying to show me how to use vlookup on excel. They are probably telling their friends how this old guy cant figure out basic excel functions right now.

Learn the Index Match formula and throw it in their face.

=index(a:a,match(b1,c:c,0),1)
I'm....on the older side and didn't learn vlookup until 2 years ago.

Now, my question is, how can I do a "vlookup" between two different sheets and have it return all instances and not just the first one it finds?
 

madguy30

Well-Known Member
SuperFanatic
SuperFanatic T2
Nov 15, 2011
57,270
55,164
113
There is nothing on TV tonight.

The olympics come at a good time to at least see some high stakes live (ish since some are recordings) competition.

When that's done we roll into football hype month which can be fun.
 

wxman1

Well-Known Member
SuperFanatic
SuperFanatic T2
Jul 2, 2008
19,936
16,304
113
Cedar Rapids
Status
Not open for further replies.