Accentuate the positive

While I was trying to find an image file on my computer that was going to be the basis for an article about something my grandfather invented, I instead ran across a bit of video I shot nearly 14 years ago. (Never found what I was originally looking for, though.)

To give it some context, I shot the video on a camera that I’d just bought around that time as an early Christmas present to myself. The reason for that was because a gig that had started out as a “two day only” temp assignment in the middle of the previous July had turned into a full-time job that lasted over a decade by the end of that October. I shot the video over the course of a work day that was also the day of our office holiday party, my first with the company.

That camera stopped being compatible with my operating system a couple of updates ago, but that’s okay. My phone shoots higher resolution video anyway.

It was strangely nostalgic to see all of my former coworkers again, though. In fact, out of everybody in the video, only two of them made it with me all the way to the end, when the company self-destructed. Ironically, I still work with one of them now, for a completely different company.

But that’s not what this story is about. It also brought up the feels because that particular office — the first of four which the company occupied during my time with it — was long since converted into a Target Express, a sort of mini-version of the bigger stores. I visited it once, and bought a DVD about twenty feet from where my desk had been.

But, the point of the story: In this video, I was interviewing coworkers and narrating and I was once again reminded of how much I hate the sound of my own voice when I hear it coming from anywhere that isn’t inside my own head.

This is not at all uncommon. In fact, when I googled it, I only had to type “Why do people hate” before it auto-filled with the rest of the question — “the sound of their own voices.” Basically, when you talk, the sound you hear isn’t coming through the air. It’s coming directly through the bones in your ear, so the voice you hear is probably deeper and richer.

In my case it’s even weirder than that. The voice I hear in my head lacks two things that are very obvious when I listen to it recorded. One: I’m a lot more nasally than I think I am. Two: I actually have a noticeable accent, although I really can’t place it. I won’t count one other bit as three, though, because it’s true of everyone — the voice outside my head is probably half an octave higher than the one in my head.

The other noticeable thing, to me at least, though, is that despite being gay I absolutely do not have “gay voice.” And yes, that’s a thing. And despite being Californian, I do not have surfer dude voice or Valley guy voice either. I also exhibit none of the vowel shifts that are apparently part of the “California accent,” whatever that is.

Another complication is that, since the entertainment industry is centered here, the standard accent of film and TV is also pretty much how Californians, particularly of the southern variety, talk.

But, to me, the non-California accent I apparently have is really baffling. Well, at least the part about not being able to place it. I was born and raised in Southern California and so was my father. However, his parents came from Kansas (although his mother was born in Oklahoma) and my mother was from Northeastern Pennsylvania with parents from upstate New York.

As a kid before I started going to school, I spent a lot more time with my mom. Meanwhile, my dad’s accent was clearly influenced by his parents despite his growing up here.

The best way to describe my mom’s accent is Noo Yawk Lite. That is, while a lot of it was flat, there were certain words and vowels that just came out east-coasty. For example, a common household pet was a “dawg.” You dried your dishes or yourself with a “tahl.” The day after Friday was “Sirday” — which I think is unique to where my mom came from. Then again, apparently, the whole state has a ton of different dialects.

I talked to her sister, my aunt, recently — the last surviving sibling — and what most struck me about it is that she sounded exactly like Carrie Fisher toward the end of her life, after her voice had taken on the character and raspiness of a lifetime of overindulgence. It was the Carrie Fisher of the talk show circuit, not the Carrie of Star Wars.

Meanwhile, the Kansas side contributed a very flat, plain, and tight-lipped manner of speech, and I certainly heard this quite often from my dad’s mom, since we visited her more often than my mom’s mom, who lived ten times farther away. And although my dad’s grandfather was German, I don’t think he had a lot of influence because great-grandpa died just before my dad turned 22, and my dad’s own father sort of abandoned the family when my dad was 12. (Long story. Don’t ask.)

And none of any of this explains the way I talk. Or tawk. Oddly enough, when I’m not speaking English, I’m pretty adept at doing a Mexican Spanish accent (casi pero no completamente en el estilo chilango), although that’s probably not all that weird when you consider that the major (but not only) Spanish influence in Southern California is, in fact, from the country that most of California used to be part of.

On the other hand, when I speak German, it’s in total Hamburg Deutsch despite my German ancestors being Alsatian, mainly because my German teacher was from that very northern town. And, to be honest, I never met any of my German ancestors because they all died long before I was born — Sie sind alle gestorben bevor ich geboren werde.

To complicate things, when I’ve listened to recordings of myself speaking either Spanish or German, the most notable thing is that I am not nasally or half an octave higher at all. Or, in other words, my voice only sucks in my native language. Funny how that works, isn’t it? And the weirdest part, I suppose, is that none of that nasal thing happens in my head, even though, technically, nasal voice happens entirely in one’s head due to that whole sinus thing.

So, back to the beginning. When I speak my native language I hate the way I sound, but when I speak a foreign language, I don’t hate the way I sound. Then again, that’s also true when I’m performing onstage and playing a character. I just forget to play a character in real life, but maybe that’s a good thing.

There’s a book by Dr. Morton Cooper, first published in 1985, called Change Your Voice, Change Your Life, which posits exactly this premise. Ironically, though, he specifically mentions the flaws in voices — like Howard Cosell’s nasality and Barbara Walters nasality, hoarseness, and lisp — as their strongest points. Although his references are dated, I guess he has a point, stating that, “These personalities have all managed to project voice images that are— however unattractive and displeasing to the ears— distinctive and lucrative.”

Then… maybe I should change nothing? Hell, if Gilbert Gottfried (NSFest of W) can get away with talking the way he does, maybe I’m onto something. And maybe it’s not so much a matter of changing my voice as it is changing my feelings about it.

And that’s really the takeaway here — surprise, this was the lesson all along. There are certain things we can’t really change about ourselves, like our height, our hair, eye, or skin color, our looks, or our voices. (Okay, we can change hair, eye, or skin color through dye, contact lenses, or tanning, but those are only temporary and, in some cases, really obvious.) But we are stuck with our height, looks, and mostly our voices, unless we want to go to the expense of physically altering the first two, or learning how to alter the latter.

Or… we can just learn to accept ourselves as we are, flaws and all, and realize that we do not have to be some perfect ideal media version of a human in order for someone to love us.

And the part I intentionally left out of this up to now is this: Plenty of people have told me that I have a sexy voice. I may not agree with them at all, but if they think so, then that’s good enough for me. I mean, I got to be the Pokémon they chose before they threw their ball at me, right? And, in the end, that’s the only part that counts.

So… stop judging yourself for the flaws you think you see. Instead, listen to the flaws that people who love you clearly do not see.

Wednesday Wonders: How the world almost ended once

I happen to firmly believe that climate change is real, it is happening, and humans are contributing to and largely responsible for it, but don’t worry — this isn’t going to be a political story. And I’ll admit that I can completely understand some of the deniers’ arguments. No, not the ones that say that “global warming” is a hoax made up so that “evil liberals” in government can tax everyone even more. The understandable arguments are the ones that say, “How could mere humans have such a big effect on the world’s climate?” and “Climate change is cyclic and will happen with or without us.”

That second argument is actually true, but it doesn’t change the fact that our industrialization has had a direct and measurable impact in terms of more greenhouse gases emitted and the planet heating up. Also note: Just because you’re freezing your ass off under the polar vortex doesn’t mean that Earth isn’t getting hotter. Heat just means that there’s more energy in the system and with more energy comes more chaos. Hot places will be hotter. Cold places will be colder. Weather in general will become more violent.

As for the first argument, that a single species, like humans, really can’t have all that great an effect on this big, giant planet, I’d like to tell you a story that will demonstrate how wrong that idea is, and it begins nearly 2.5 billion years ago with the Great Oxygenation Event.

Prior to that point in time, the Earth was mostly populated by anaerobic organisms — that is, organisms that do not use oxygen in their metabolism. In fact, oxygen is toxic to them. The oceans were full of bacteria of this variety. The atmosphere at the time was about 30% carbon dioxide and close to 70% nitrogen, with perhaps a hint of methane, but no oxygen at all. Compare this to the atmosphere of Mars today, which is 95% carbon dioxide, 2.7% nitrogen, and less than 2% other gases. Side note: This makes the movie Mars Attacks! very wrong, because a major plot point was that the Martians could only breathe nitrogen, which is currently 78% of our atmosphere but almost absent in theirs. Oops!

But back to those anaerobic days and what changed them: A species of algae called cyanobacteria figured out the trick to photosynthesis — that is, producing energy not from food, but from sunlight and a few neat chemical processes. (Incidentally, this was also the first step on the evolutionary path to eyes.) Basically, these microscopic fauna would take in water and carbon dioxide, use the power of photons to break some bonds, and then unleash the oxygen from both of those elements while using the remaining carbon and hydrogen.

At first, things were okay because oxygen tended to be trapped by organic matter (any carbon containing compound) or iron (this is how rust is made), and there were plenty of both floating around to do the job, so both forms of bacteria got along fine. But there eventually became a point when there were not enough oxygen traps, and so things started to go off the rails. Instead of being safely sequestered, the oxygen started to get out into the atmosphere, with several devastating results.

First, of course, was that this element was toxic to the anaerobic bacteria, and so it started to kill them off big time. They just couldn’t deal with it, so they either died or adapted to a new ecological niche in low-oxygen environments, like the bottom of the sea. Second, though, and more impactful: All of this oxygen wound up taking our whatever atmospheric methane was left and converting it into carbon dioxide. Now the former is a more powerful greenhouse gas, and so was keeping the planet warm. The latter was and still is less effective. The end result of the change was a sudden and very long ice age known as the Huronian glaciation, which lasted for 300 million years — the oldest and longest ice age to date. The result of this was that most of the cyanobacteria died off as well.

So there you have it. A microscopic organism, much smaller than any of us and without any kind of technology or even intelligence to speak of, almost managed to wipe out all life forms on the planet and completely alter the climate for tens of millions of years, and they may have tipped the balance in as little as a million years.

We are much, much bigger than bacteria — about a million times, actually — and so our impact on the world is proportionally larger, even if they vastly outnumbered our current population of around 7.5 billion. But these tiny, mindless organisms managed to wipe out most of the life on Earth at the time and change the climate for far longer than humans have even existed.

Don’t kid yourself by thinking that humanity cannot and is not doing the same thing right now. Whether we’ll manage to turn the planet into Venus or Pluto is still up for debate. Maybe we’ll get a little of both. But to try to hand-wave it away by claiming we really can’t have that much of an impact is the road to perdition. If single-celled organisms could destroy the entire ecosystem, imagine how much worse we can do with our roughly 30 to 40 trillion cells, and then do your best to not contribute to that destruction.

A company town

Despite its size, Los Angeles is a company town, and that company is entertainment — film, television, and music, and to a lesser extent gaming and internet. So, growing up here, seeing film crews and running into celebrities all over the place was always quite normal. Hell, I went to school with the kids of pretty big celebrities and never thought much of it. “Your dad is who? Whatever.”

It looks like that company is finally coming back to life after fifteen months of being semi-dormant. It’s tentative, of course, and we may wind up locking down again, especially if a vaccine-resistant variant suddenly pops up. But, for the moment, movie theaters and live venues are reopening, along with the restaurants and other businesses that survived.

But here’s one thing I don’t think a lot of non-locals understand: None of the major studios are actually in Hollywood. How the city of Hollywood — which is where I was actually born — became conflated with the movies is a very interesting story. Once upon a time, there were some studios there. Charlie Chaplin built his at La Brea and Sunset in 1917. It was later owned by Herb Alpert, when it was A&M Studios and produced music. Currently, it’s the location of the Jim Henson Company. The Hollywood Hills were also a popular location for celebrities to live, and a lot of the old apartment buildings in the city were originally designed for young singles who worked in the industry.

Come to think of it, they still serve that purpose, although given the cost of rent in this town, a lot of those studio units are cramming in two tenants.

The one thing that Hollywood did have in abundance: Movie premieres, and that’s still the case to this day. The Chinese, The Egyptian, and the El Capitan are perennial landmarks, and the Boulevard itself is quite often still closed down on Wednesdays for red carpet openings. Although Broadway downtown also boasts its own movie palaces from the golden age of cinema, it was always Hollywood Boulevard that had the great grand openings. It’s also still home to the Pantages, which is the biggest live theater venue outside of downtown, although they generally only do gigantic Broadway style musicals. (Side note on the Chinese Theater — although it’s technically called the TCL Chinese because, owners, nobody refers to it that way, and you’re still more likely to hear it called what it always was: Grauman’s Chinese Theater. Want to sound like a local? That’s how you do it. You’re welcome.)

There is one Hollywood tradition that does not date from the golden age of cinema, though, and it might surprise you. The Hollywood Walk of Fame wasn’t proposed until the 1950s, and construction on it didn’t begin until 1960 — long after all of the movie studios had left the area.

In case you’re wondering where those studios went, a number of them are in the oft-derided Valley: Universal in Universal City (they like to call themselves “Hollywood” but they’re not), Warner Bros. in Burbank, Disney in Burbank and Glendale, and Dreamworks Animation SKG in Glendale (across from Disney Animation!) all come to mind — and damn, I’ve worked for three out of four of them. On the other side of the hill, in L.A. proper, Sony is in Culver City, 20th Century Fox is in Century City (which was named for the studio), and Paramount is in L.A. proper, right next to RKO, which really isn’t doing much lately, both due south of Hollywood and right behind the Hollywood Forever Cemetery — which isn’t in Hollywood either, but which has a large number of dead celebrities. I think that covers most of the majors. YouTube Studios is in Playa del Rey, on the former sight of the Hughes helicopter factory that also happens to be right below the university I went to for film school, Loyola Marymount.

Like I said, company town.

The other fun part about growing up here is all of the film locations that I see every day, and there are tons. Ever see Boogie Nights? Well, most of that film was basically shot within a five mile radius of where I grew up, with only a few exceptions. Dirk Diggler’s fancy new house once he became a porn star? Yeah, my old hood. Location of the club where Burt Reynold’s character finds Mark Wahlberg’s character? I took music lessons a few blocks away from there. Parking lot where Dirk is mistakenly gay-bashed? Pretty close to the public library where I fell in love with reading.

Remember The Brady Bunch or the movies? Well, that house is only a couple of miles away from where I live now. The OG bat cave? Let me take you to Griffith Park. If you’ve ever seen Myra Breckenridge (you should if you haven’t) the place where Myra dances in the opening is right next to where Jimmy Kimmel does his show now and two doors down from the now Disney-owned El Capitan.

The Loved One (an amazing movie) — Forest Lawn Glendale, where I happen to have at least four ancestors buried. Xanadu? The major setting was the Pan Pacific Auditorium, which was a burned down wreck in my day, but it’s where my dad used to go on date night to roller skate. Go to the Vista Theatre? It sits on the site where D.W. Griffith built one of his biggest sets for Intolerance, his “mea culpa” for making The Birth of a Nation.

I’m not even going to get into how many times the complex I live in has been used for various epic TV shoots (which is a lot) or, likewise, how the area in NoHo I worked in is used by everybody, from YouTubers to major studios. Although, I can tell you that having to put up with film crews and their needs is always a major pain in the ass, especially when it comes to parking vanishing. That’s right — there’s really no glamor in show biz outside of that red carpet.

But I guess that’s the price of admission for growing up and living in a company town and, honestly, I’ve never had a single adult job that wasn’t related to that company ever. (We won’t count my high school jobs as wire-puller for an electrical contractor and pizza delivery drone.)

Otherwise, though — yep. Whether it’s been TV, film, theater, or publishing, I’ve never not worked in this crazy stupid industry that my home town is host to. And I really wouldn’t have it any other way. What? Wait tables? Never. Although sharing my home town with tourists is a distinct possibility. I love this place. A lot. And you should too, whether you’re a visitor or a transplant. Welcome!

Wednesday Wonders: Seeing the real magic

In honor of the Magic Castle slowly reopening, here’s a reprint of a piece inspired by my visit long ago to the place, in November 2018. It was my second trip but, I hope, not my last.

And now for a story that starts out a bit Hollywood-centric, but it will become more general as we go on.

I recently made another foray to The Magic Castle in Hollywood, which isn’t quite as hard to manage as it’s reputed to be. All you have to do is befriend magicians, and ask — or know people who know magicians. Or, if you have the money, you can become an associate member for a $1,500 initiation fee and $750 per year, or just stay in the adjacent Magic Hotel. If you’re into magic, it’s well worth the visit.

If you don’t have that kind of money and have to rely on connections, note that the valet parking is a bit pricey at $14 per car, but if you don’t mind a walk you can get there from the Hollywood and Highland Metro Station, or just use a ride-sharing service. The food is excellent but, again, on the higher end. However, eating in the dining room does get you admission to the main room shows, which is where the big effects happen, so factor that into the price of the meal. If you don’t mind missing the big shows but are still hungry, food at either of the bars is in the typical restaurant range for L.A., and it is likewise very good.

Now, like a lot of people who were once little kids, I went through my fascination with magic phase, and had the obligatory kits and tricks. There was also a magic shop a few miles from my house that I used to ride my bike to during my middle school days, and the owner was kind enough to let me hang around and watch him demonstrate tricks or watch magicians try out new effects or card moves.

The only problem was that when it came to doing magic I did not have the manual dexterity for it. My hands were adapted to playing piano, not to sleight-of-hand, so unless a trick did itself, I wasn’t very good at it, so I never pursued it. For a long time, I kind of resented magicians for this reason, until I discovered Penn & Teller. Their whole shtick is partly about revealing how some old classic tricks are done, but even then they’ll top it by using the exposed version to show what kind of mad skills it takes, or subvert it by then hiding a bigger trick behind the reveal — in effect showing you everything while hiding something even more amazing.

Anyway, it was ironically through their giving away of secrets (something that some other magicians absolutely hate them for) that really increased my appreciation of magic. I went on to learn about how all sorts of tricks worked, but then watching magic became an entirely different sort of thing for me. Audiences who don’t know the tricks (no, I’m not going to call them No-Maj, thanks!) are wowed and amazed and baffled. Meanwhile, when I watch, I appreciate the sheer talent of a skilled magician while I watch exactly how they’re misdirecting the audience. I may know the punchline to the trick the moment the magician sets it up and long before it’s revealed, but that’s an entirely different level of enjoyment.

I’d compare it to the difference in experience between a musician and a non-musician watching a performance. The latter may just appreciate the music on an emotional and aesthetic level. Meanwhile, the former may be watching it from a completely different place, which could very well offer frequent thoughts of, “Holy crap, how did they make those two keys fit together in counterpoint and have two separate lyric lines suddenly mesh perfectly?” (This is also known as “pulling a Sondheim.”)

The other night at The Magic Castle, I was lucky enough to be sitting at the right hand of the close-up magician who had invited my friend as he did a half-hour routine especially for our group at a green felt-topped table that was quickly surrounded by spectators not in the inner circle. And for his whole routine, I knew enough to ignore the misdirection and always watch what the hand he didn’t want us to look at was doing. I did catch one specific move that I think may have actually been just to fake me out because it shouldn’t have been necessary for the trick that followed, but as I found out afterwards, he was as onto me as I was to him. When I complimented him afterwards,  he said, “You’ve done magic, haven’t you?”

“No, I’ve just studied it a lot,” I replied.

During his routine, while everyone else was watching what he wanted them to, I was just as enthralled watching how skillfully he was pulling off what he was hiding — every palm and ditch, force and false cut, load and steal, every stack and double lift. In magician’s terms, I was giving him a burn. But my intent was never to go, “A-ha, you just (reveal trick)!” No. It was to be awed on an entirely different level. His skills are absolutely amazing.

The Magic Castle is like that, and the place is full of little bits of magic to be discovered, but probably one of the most remarkable is Irma, the ghost piano player who performs in the lounge behind the upstairs bar. The effect is simple. When she’s not on break, ask Irma for a song, and unless it’s something ridiculously obscure, she’ll start playing it. (I stumped her with Echame la culpa, but I figured that it wouldn’t be in her repertoire anyway.)

She’ll also answer questions with short musical bits. For example, someone in our party asked if she was in love with anyone, and this was answered with “I’m Just Wild about Harry.”

Obviously, the grand piano with no one sitting in front of it is somehow remotely operated, but the big question is how. And remember: Irma has been a part of The Magic Castle all along, since its opening in 1963, at which point the effect presented itself exactly the same way, more on which in a moment.

I’ve heard people theorize on it, conjecturing everything from tons of player piano rolls, to voice recognition and AI, to a hidden player pulling up sheet music via computer. And, of course, it all works through hidden microphones. The first two are unlikely, the third is unnecessary, and the microphones don’t explain everything that happens.

Once you start really paying attention to what’s going on, you’ll discover that there’s one thing a lot of people don’t realize. In fact, I didn’t realize it until we walked into the lounge with our magician host and Irma immediately started playing The Pink Panther, which he pointed out is his theme song. Also, when he set his trick bag on the table in front of us and went to the bar, the table slowly rotated so the bag was suddenly in front of me. When he game back, we told him what had happened and he said it was just Irma’s way of being funny.

After that, one of our party joined us with a glass of tequila and yes — Irma played a few bars of that song. Much later in the evening, after we paid one last visit to Irma and were on the way out, she started playing Anything Goes — the first song asked for that night by the one member of our party who’d never been there before and who had had the tequila. He had started walking out without a word.

So there’s no possible way that it’s just microphones, but I could not spot any likely place for cameras to be hidden. Not that it’s not possible, although it’s more likely that they still rely on the low-tech method of people with microphones behind two-way mirrors to relay information to the — pardon the expression — ghost in the machine that is the human player hidden somewhere. This would certainly be a logical use of some very old mind-reader act trickery, after all.

Personally, I’m entirely convinced that Irma is operated by a human piano player who is not relying on computers or AI or any other fancy technology. Rather, it’s a human who is just relying on their own talents and skill. And that is the biggest magic trick of all.

Remember that the next time someone amazes you with what they can do, and thank them for it — then go out there and be amazing at what you do.

To my American readers, Happy Thanksgiving! ¡Feliz día de la acción de gracias!

Talky Tuesday: False friends and other stuff

As I wrote about previously, learning at least one other language is something that’s good for your brain, and not necessarily as hard to do as you might think, especially depending on how your native and second languages are related. For an English speaker, Germanic and Romance languages are probably easier to learn than Semitic or Japonic languages. Not necessarily the case — I know plenty of Americans who’ve learned Hebrew as pre-teens or learned Japanese because of a love of Anime and Manga — but sticking to other languages with common roots will help.

And if you learn one language from a family, while you may not be able to fluently speak related languages, you may at least be able to understand them. From learning Spanish, I can often understand spoken Italian, as well as frequently be able to read French and Portuguese. No such luck with Romanian, though. And yes, although it might be a surprise to some people, Romanian is a Romance Language, too. In fact, it’s the one that gave the family its name. Because I’d studied German, Dutch made sense to me when I dabbled in it. And so on.

But… a funny thing can happen as languages diverge from their origins and change. All of the Romance languages came from Latin. They are the remnants of the Roman Empire, after all. But all of them evolved and changed until they went from being street dialects of the imperial tongue to their own very separate things.

The same thing happened with English. It started out as a language spoken by a tribe on an island off of the west coast of Europe with influences from a different language from other tribes on an island off of that island’s west coast. This got a heavy early dose of Latin thanks to Roman invaders. Then, a few centuries later, it was infused with Nordic Languages via the Vikings and, for a while, the kings there were Danish.

That all ended when ol’ William the Conqueror came roaring in in 1066, bringing French with him. In fact, for a long time, the nobility spoke French while the peasants spoke English and everybody went to church in Latin.

We can still see remnants of the Norman Conquest today. It’s so often cited that it’s not really news, but that’s why we have different words for the animals: cow, pig, chicken, sheep; and for the meat from them, beef, pork, poultry, mutton. The former are all old Anglo-Saxon terms and the latter are French. The peasants grew the stuff. The nobility ate it.

The French roots are still really obvious in the latter: boeuf, porc, poulet, mouton. Meanwhile, the Germanic roots are really clear in the Anglo-Saxon words: Kuh, Schwein, Huhn, Schaf. The one odd one might seem to be chicken, Huhn or Hähnchen, until you remember that we call a female chicken a… hen.

Side note, looking at poulet and mouton: The reason that a lot of English words in British spelling have –ou where the American versions have just –o is that Samuel Johnson had a jones for preserving etymology, so words derived from French kept the French spelling — colour, behaviour, etc. Johnson was kind of a pedant — which is just a fancy Latin-based word for “douche.” But I do digress.

The real point here is this: One of the big bugbears that language learners do face is what are called “False Friends.” That is, words in two different languages that look like each other, but actually have very different meanings. At their most harmless, they can lead to silly misunderstandings. At their most harmful, well… that’s self-explanatory.

Probably one of the most famous examples that any English speaker who takes Spanish 101 learns almost off the bat is this one: Embarazada. For those of you who haven’t studied Spanish, I’ll give you a moment to take a guess at what this word means. Hint: It’s an adjective.

While we’re waiting: One of the funniest (to me) Spanish errors someone can make is to leave the tilde off of the “n” in the word “años,” which means years. In Spanish, the phrase is not “He is X years old,” it is “He has X years.” So leaving the tilde off changes a statement like, “My grandfather (is) has seventy years (old)” to “My grandfather has seventy anuses.”

As for embarazada, what’s your guess? If you said embarrassed, then be embarrassed, because it actually means pregnant.

Speaking of actually… it’s generally easy to convert adverbs from English and Spanish and mostly be right. Adverbs that end with –ly in English end with –mente in Spanish. Probably, probablamente. So the word actualmente might look like it means actually… but it doesn’t. It means currently, as in “right now.” Actualmente escribo un artículo por mi blog. Right now, I’m writing an article for my blog.

Easey peasey. Or, in Spanish, pan comido, which literally means “eaten bread,” but I think you can see how that relates to another English saying: “piece of cake.”

Other fun false friends: Carpeta is not a carpet, which is alfombra, a word that Spanish borrowed from Arabic. Rather, carpeta is a folder, particularly a file folder. You’ll see this word all the time if you switch your devices to Spanish.

And there’s another one. Dispositivo might look like it has to do with disposing stuff, but it doesn’t. This is the word for devices, particularly phones and tablets.

If you work for a business or company, then you might feel like they’re getting all imperial on you. Easy mistake to make if you misinterpret the Spanish word therefore: Empresa.

Looking for a way out? Then you don’t want the éxito, which is actually a big hit — un gran éxito is a song or movie or TV show that earns a lot of money. If you really want to go, look for la salida.

If you want to introduce someone in Spanish, then don’t use introducir, because that means to insert something, and I don’t think you want to get that intimate with your… um… introductions. Instead, use presentar.

On the other hand, molestar in Spanish is a lot more innocuous than it is in English. If you molestas alguien en español, at most they’ll look at you funny and walk away. If you molest someone in English, you’ll probably wind up in jail and on a list. Molestar in Spanish simply means “to bother.” As Winnie the Pooh might say, “Ay, que molesta.”

Then, there’s this one: Fingir. I know what it looks like, but what it really means is “to pretend.” But if you go around fingering people in English… well, without their consent, don’t.

Finally, if you want to wash up, don’t reach for the sopa unless you want to bathe in soup. Otherwise, what you want is jabón… not to be confused with the Spanish word for ham, which is jamón. And this word may or may not have appeared in Michael Jackon’s “Bad.”

I haven’t done this in reverse, but let me know if you can. If you’re a non-native speaker learning English, what words in our language look like but aren’t words in your own? And if you’re an English speaker learning something other than Spanish, what false friends pop up in your target language?

Comment below!

Talky Tuesday: If you love it, you’ll learn it

When you’re learning a new language, there’s one excellent method to increase your vocabulary and improve your fluency, and here it is.

Different people have different learning styles. Some people learn visually. That is, if they see it, they won’t forget it. Others are auditory learners, who pick things up via hearing. And there are also people whose learning method is tactile, through touch or physical motion.

Now, some of those skills seem to apply obviously to certain disciplines. Painters are probably visual learners, musicians are auditory, and dancers are tactile. In the case of language, you might think that it’s an auditory skill, but that’s not necessarily the case. Fortunately, you can use different tricks to learn a new language via your own method.

For visual people, it’s all about words, so the obvious best natural ways for visual learners to pick up a new language are reading and watching.

For auditory people, it’s all about sound, so they’re going to want to listen, although videos won’t hurt if they do have sound as well.

For tactile people, it’s all about sensations, so they’re going to be doing a lot of writing things down by hand.

That part of the lesson may seem like a “Well, duh” moment, but the key is in what you’re reading, listening to, or writing. If you want to learn a new language, treat it like your first language.

That is, whether you’re reading, listening, watching, or writing, you’re going to want to do it with things on subjects that interest you. I can’t emphasize this enough. What you should be doing is seeking out online resources in your target languages — generally newspaper and magazine sites — and then focus on the sections that pertain to your interests.

Whether you’re a fan of movies, TV, sports, fashion, politics, or whatever, if the content in the target language you’re scooping into your brain via your preferred method happens to be about topics you already love, then your contextual understanding is going to go through the roof.

Why? Well, because specialized topics happen to use specialized words, and the quickest way to start to understand the heart of a language — which is how words are derived, how idioms are formed, and so on — is to pick up those words that were created to describe your favorite topic.

I’m a fan of film and theater, for example, so a word I see a lot is taquilla, which means box office. As in English, it’s both a literal and metaphorical meaning. It can refer to the physical place where tickets are sold or to the amount of money a film or play took in.

But where did taquilla come from? Well, like a lot of words in Spanish, it came from Arabic (La Conquista lasted for centuries), and taquilla is a diminutive for “taca.” That word, in turn, came from the Arabic taqah, which referred to a window with bars — a good physical description of a lot of actual box offices, actually.

Incidentally, pretty much any word in Spanish that begins with “al” came from Arabic, where the al- prefix just means “the,” similar to how Spanish combines the articles “a” (to) and “el” (the) into “al.” For example, algodón, which means cotton, and which is also the source of the English word; or alfombra, which means carpet, and this gets back to the focusing on what you love idea. Alfombra was permanently cemented in my brain after seeing it in a few articles about movie premieres always in this context: “en la alfombra roja.” On the red carpet.

The best part is that this is not just limited to Spanish, thanks to the internet (either la internet or la red), because you can probably pretty much find resources in any target language somewhere. If you want to read, you can find national newspapers in the native language and probably plenty of websites — and it will also be a big help to adjust Google’s language settings to include your target. If you want to watch or listen, then there are also tons of videos in other languages. And if you learn by writing, you’ll need source material, so transcribing audio or copying the written word will help as well.

But, again, the key to it is this one simple bit: engage with what you’re interested in in the first place, and it will make your target language come alive in a way that rote lessons or drills or routines never will.

Love it, live it, learn it!

Image © Syed Ikhwan. Used via Creative Commons license 2.0.

Wonderous Wednesday: 5 Things that are older than you think

A lot of our current technology seems surprisingly new. The iPhone is only about fourteen years old, for example, although the first Blackberry, a more primitive form of smart phone, came out in 1999. The first actual smart phone, IBM’s Simon Personal Communicator, was introduced in 1992 but not available to consumers until 1994. That was also the year that the internet started to really take off with people outside of universities or the government, although public connections to it had been available as early as 1989 (remember Compuserve, anyone?), and the first experimental internet nodes were connected in 1969.

Of course, to go from room-sized computers communicating via acoustic modems along wires to handheld supercomputers sending their signals wirelessly via satellite took some evolution and development of existing technology. Your microwave oven has a lot more computing power than the system that helped us land on the moon, for example. But the roots of many of our modern inventions go back a lot further than you might think. Here are five examples.

Alarm clock

As a concept, alarm clocks go back to the ancient Greeks, frequently involving water clocks. These were designed to wake people up before dawn, in Plato’s case to make it to class on time, which started at daybreak; later, they woke monks in order to pray before sunrise.

From the late middle ages, church towers became town alarm clocks, with the bells set to strike at one particular hour per day, and personal alarm clocks first appeared in 15th-century Europe. The first American alarm clock was made by Levi Hutchins in 1787, but he only made it for himself since, like Plato, he got up before dawn. Antoine Redier of France was the first to patent a mechanical alarm clock, in 1847. Because of a lack of production during WWII due to the appropriation of metal and machine shops to the war effort (and the breakdown of older clocks during the war) they became one of the first consumer items to be mass-produced just before the war ended. Atlas Obscura has a fascinating history of alarm clocks that’s worth a look.

Fax machine

Although it’s pretty much a dead technology now, it was the height of high tech in offices in the 80s and 90s, but you’d be hard pressed to find a fax machine that isn’t part of the built-in hardware of a multi-purpose networked printer nowadays, and that’s only because it’s such a cheap legacy to include. But it might surprise you to know that the prototypical fax machine, originally an “Electric Printing Telegraph,” dates back to 1843.

Basically, as soon as humans figured out how to send signals down telegraph wires, they started to figure out how to encode images — and you can bet that the second image ever sent in that way was a dirty picture. Or a cat photo.

Still, it took until 1964 for Xerox to finally figure out how to use this technology over phone lines and create the Xerox LDX. The scanner/printer combo was available to rent for $800 a month — the equivalent of around $6,500 today — and it could transmit pages at a blazing 8 per minute. The second generation fax machine only weighed 46 lbs and could send a letter-sized document in only six minutes, or ten page per hour. Whoot — progress!

You can actually see one of the Electric Printing Telegraphs in action in the 1948 movie Call Northside 777, in which it plays a pivotal role in sending a photograph cross-country in order to exonerate an accused man.

In case you’re wondering, the title of the film refers to a telephone number from back in the days before what was originally called “all digit dialing.” Up until then, telephone exchanges (what we now call prefixes) were identified by the first two letters of a word, and then another digit or two or three. (Once upon a time, in some areas of the US, phone numbers only had five digits.) So NOrthside 777 would resolve itself to 667-77, with 667 being the prefix. This system started to end in 1958, and a lot of people didn’t like that.

Of course, with the advent of cell phones, prefixes and even area codes have become pretty meaningless, since people tend to keep the number they had in their home town regardless of where they move to, and a “long distance call” is mostly a dead concept now as well, which is probably a good thing.

CGI

When do you suppose the first computer animation appeared on film? You may have heard that the original 2D computer generated imagery (CGI) used in a movie was in 1973 in the original film Westworld, inspiration for the recent TV series. Using very primitive equipment, the visual effects designers simulated pixilation of actual footage in order to show us the POV of the robotic gunslinger played by Yul Brynner. It turned out to be a revolutionary effort.

The first 3D CGI happened to be in this film’s sequel, Futureworld in 1976, where the effect was used to create the image of a rotating 3D robot head. However, the first ever CGI sequence was actually made in… 1961. Called Rendering of a planned highway, it was created by the Swedish Royal Institute of Technology on what was then the fastest computer in the world, the BESK, driven by vacuum tubes. It’s an interesting effort for the time, but the results are rather disappointing.

Microwave oven

If you’re a Millennial, then microwave ovens have pretty much always been a standard accessory in your kitchen, but home versions don’t predate your birth by much. Sales began in the late 1960s. By 1972 Litton had introduced microwave ovens as kitchen appliances. They cost the equivalent of about $2,400 today. As demand went up, prices fell. Nowadays, you can get a small, basic microwave for under $50.

But would it surprise you to learn that the first microwave ovens were created just after World War II? In fact, they were the direct result of it, due to a sudden lack of demand for magnetrons, the devices used by the military to generate radar in the microwave range. Not wanting to lose the market, their manufacturers began to look for new uses for the tubes. The idea of using radio waves to cook food went back to 1933, but those devices were never developed.

Around 1946, engineers accidentally realized that the microwaves coming from these devices could cook food, and voìla! In 1947, the technology was developed, although only for commercial use, since the devices were taller than an average man, weighed 750 lbs and cost the equivalent of $56,000 today. It took 20 years for the first home model, the Radarange, to be introduced for the mere sum of $12,000 of today’s dollars.

Music video

Conventional wisdom says that the first music video to ever air went out on August 1, 1981 on MTV, and it was “Video Killed the Radio Star” by The Buggles. As is often the case, conventional wisdom is wrong. It was the first to air on MTV, but the concept of putting visuals to rock music as a marketing tool goes back a lot farther than that.

Artists and labels were making promotional films for their songs back at almost the beginning of the 1960s, with the Beatles a prominent example. Before these, though, was the Scopitone, a jukebox that could play films in sync with music popular from the late 1950s to mid-1960s, and their predecessor was the Panoram, a similar concept popular in the 1940s which played short programs called Soundies.

However, these programs played on a continuous loop, so you couldn’t chose your song. Soundies were produced until 1946, which brings us to the real predecessor of music videos: Vitaphone Shorts, produced by Warner Bros. as sound began to come to film. Some of these featured musical acts and were essentially miniature musicals themselves. They weren’t shot on video, but they introduced the concept all the same. Here, you can watch a particularly fun example from 1935 in 3-strip Technicolor that also features cameos by various stars of the era in a very loose story.

Do you know of any things that are actually a lot older than people think? Let us know in the comments!

Photo credit: Jake von Slatt

Going, gone, went…

When it comes to verb conjugations, English can be a little weird. Some verbs seem to barely change. For example, a regular verb like “to look” uses the present form look for I, you, we, and they. The only one that changes is third person singular — he/she/it looks. The past participle is looked for all persons, and so forth.

But then we get the irregular verbs, which can be even more irregular than they are in other languages: I am, you are, he/she/it is, we are, they are. But one of the stranger ones, which I hear misused a lot by both English learners and native speakers, is the compound past tense of “to go.” (Note: for some reason, to be and to go seem to be totally irregular in every language, which is strange considering how common they are.)

The present of “to go” is regular — go or goes, the same as to look, above. But there are two forms we can use in the past: gone and went. You’d never say “I goed away.” It’s “I went,” and the form is went for all persons as well. This is great right up until you combine it with an auxiliary verb. Logic might seem to be that “I had went” would be correct, but it isn’t. This is where the other version comes in. The correct phrasing is “I had gone.” And, by the way, it’s also “had” for any person: You had gone, she had gone, etc.

The difference is that went is the past tense, while gone is the past participle. Again, this is one of those areas where sometimes English words change a little and sometimes they change a lot. For “to look,” for example, the past tense and participle are both the same: looked. The difference is that the participle always needs another verb before it while the past does not. So if the word before is not a verb, the word you want is went. Otherwise, it’s gone.

To add to the confusion: Gone can also be an adjective but went cannot, so we can have a sentence like “They will be gone for the month of November,” but not “They will be went for the month of November.” Even though gone in the first sentence follows a verb, it’s functioning as an adjective there, describing the state they will be in for November.

On a related note, I also hear the present continuous conjugation of “to stand” formed incorrectly a lot. Present continuous is the tense that combines the verb “to be” with the present participle of another verb, which is the –ing tense in English. For example, “We are looking for a few good men.” That one is pretty straightforward, so it would seem obvious that the correct form is “He is standing in the street.”

It might seem obvious, and yet I hear abominations like “He is stood in the street” all the time. Okay, that form of to stand doesn’t have the obvious –ed ending of a lot of English past participles, but at least it does have a D. On top of that, I never hear anyone say something like “You are looked for Waldo.” That just makes no sense.

So yeah, a sentence like “We had went outside and now are stood on the corner” would make my skin crawl. Oddly enough, the same thing can happen with the verb to sit, as in the incorrect “She is sat at the table” versus the proper “She is sitting at the table.” The former is non-standard English and should be avoided.

The article I linked in the previous paragraph has some useful examples of irregular verbs that do make the error obvious if you test them: I was ran down the road, and he is flown to New York. Even though they don’t follow the usual –ed construction of the participle, the incorrectness should be pretty obvious to native speakers. Ironically, though “he was flown” can be a proper construction if the verb becomes transitive. That is, “he” becomes the direct object of the sentence: He was flown to New York by the contest sponsors.

Isn’t language just so much fun?

The one thing I will say about the mongrel beast that is my native language English: It can put up with a lot of mangling and still make perfect sense, or at least be understandable. A lot of other languages cannot handle that. Misplace a pronoun or adjective or derp up a verb, and the entire sentence becomes gibberish.

One of the most classic examples of this, which long ago achieved meme status, is the entire opening dialogue from a 1989 video game called Zero Wing. I encourage you to click that opening dialogue link and read the “Official Translation” column, because it a glowing example of machine translation gone wrong. Nothing is right in how the words went from Japanese to English, and yet it still makes sense. This is the source of several famous internet memes, including “Somebody set up us the bomb” and “All your base are belong to us.”

And for an example that intentionally aims for gibberish and yet still makes sense, you can’t beat Lewis Carrol’s classic poem “Jabberwocky.” The man was weird, but he was a genius all the same. (Just check out “The Hunting of the Snark,” for example.)

Then again, English is also absolutely capable of sentences that make complete sense semantically, and yet still mean nothing. Try to wrap your head around “Colorless green ideas sleep furiously,” for example. It’s a noun adjective combo that can verb in an adverbial way, and yet…

Don’t think about it too hard, or else you may find that you have went mad and aren’t sure where you’re now stood.

That hurt to write.

When it’s “its”

Even Microsoft Word’s spell-check gets this one wrong sometimes, but you shouldn’t. Here’s the scoop on possessives that don’t take apostrophes.

I could write tons and tons on the use of apostrophes, but there are already plenty of guides online. So, instead, I’m going to focus on one area that causes a lot of confusion: Possessive pronouns that do not have apostrophes.

There are eight of them, five of which end in an S and one of which ends in an S sound, although the mistake is most common with only two of them — and it’s a very common error. I’ve even seen it happen on presumably professional sites like CNN and the Huffintonpost.

Here are those eight possessive pronouns:

My
Your
His
Hers
Its
Whose
Ours
Theirs

The most obvious thing about them on sight, of course, should be that there are no apostrophes to be seen. They aren’t necessary because these words are always possessive. For some of them, that doesn’t seem to cause any problems. I don’t think I’ve ever seen anyone use hi’s or her’s or our’s or their’s. That doesn’t mean this hasn’t happened; just that I can’t remember seeing it.

But I see “it’s” and “who’s” get misused all of the time — probably because both of them are perfectly legitimate words. It’s just that these two are contractions and not possessives. They just happen to look a lot like possessives, hence the confusion.

At least in the case of its, it’s a very easy typo to make, and I’ve caught myself doing it accidentally from time to time — hence the importance of proofreading. Of course, before you can proofread, you have to know the rules.

For “it’s” and “who’s,” the easiest way to remember is to always read them in uncontracted form. It’s helpful that the apostrophe even sort of looks like a little letter “i.” (Well, only sort of, but go with me on this one.) So, when you see “it’s” or “who’s,” read them in your head as “it is” and “who is.”

This makes it easy to spot their misuse:

The cat licks it’s paws.
The cat licks it is paws.

Oops. Wrong word! “The cat licks its paws.” Conversely:

It’s time to go.
It is time to go.

Right word!

Yes, it doesn’t make a lot of sense that we have these words that are possessive but don’t use apostrophes, but I never said that English does make sense. However, it is a fairly standard feature of a lot of languages that possessive pronouns work a little differently than regular possessives.

English used to have — and many languages still do — an entire grammatical case to show possession, so at least take heart in that fact: You only have to learn a few apostrophe exceptions instead of a completely new set of inflections for nouns!

Stupid Excel tricks #1: INDEX and MATCH

Enter the matrix… math

There is an entire class of functions in Excel that take things to a whole new level, and they are called matrices. Maybe you ran across this in math in school and have forgotten, maybe not, but the idea with a matrix is that it takes one grid of numbers of X x Y dimensions and uses operators to manipulate it using another grid of numbers that may or may not have the same dimensions.

The great part is that to use these functions in Excel, you don’t need to know any of that. Like I’ve mentioned before, it’s exactly like using a cookbook. Plug in the ingredients as specified, voila, the dish pops out the other end.

Maybe you’ve used the functions VLOOKUP and HLOOKUP, or maybe not, but they can be useful if you want to match exactly one criteria in a table and if the data you’re looking up is somewhere to the right of that criteria. So it’s perfect if you have something like a unique account number on the far left and want to use that to look up a name or phone number to the right of it:

=VLOOKUP(M2,$A1:$L556,6,FALSE)

This tells Excel to take the value in cell M2, compare it to all of the values in column A of the named range, then look up the value in the sixth column counting from the column defined in the second variable (in this case, F) where the first column is equal to M2. “FALSE” just means to use an exact match, whereas “TRUE” would mean to use an approximate match.

Again, this is great if you’re searching something with unique values in both places — there is only one account number, and only one data point associated with it.

Now what if you have multiple entries for the same person with different account numbers, or multiple sizes and colors of a product with differing prices, or you need to search on more than one data point in different columns, or your table was set up with the criteria you want to use somewhere to the right of the data points you’re searching?

Welcome, matrix functions! These are two nested commands that work miracles together. The first is INDEX, and what it basically does is point to a column with data that you’re going to pull stuff from, then follow that up with the criteria you’re going to use to do that. You can see the difference from the LOOKUP functions right off the bat, because those start with the single data point you’re going to use to search the data. The INDEX function starts with the place you’re going to get the answer from.

The MATCH function is the matrix math, and it allows you to specify multiple criteria matched to different columns in the source data. The nice part about it is that you can have as many different criteria as you need — first name, last name, account number; size, gender, color, style; title, author, binding, edition; and so on. And each of these can point to any particular bit of data you need — monthly cost, price, location, phone number, address, and so on. Any bit of data in the table can be found this way.

If you want to put a physical analogy on it, it’s this. LOOKUP functions are a librarian with a sliding ladder that moves horizontally or can be climbed vertically. But the way it works is that they first move it or climb it in the direction you specify until it hits the target word. Then, it slides or climbs the other direction however many rows or columns you specified, and has now targeted exactly one cell with the answer. Oh — and it can only move to the right or down from that initial search cell.

On the other hand, think of INDEX and MATCH as a whole bunch of librarians who have set out all over the same bookcases, but are simultaneously searching the rows and columns, and calling back and forth to each other to indicate what bits they’ve found that match.

If you work with any kind of inventory or any data sets where people’s info is broken down (as it should be) into separate first and last names and account identifiers, then you need to know these functions, because they will save you a ton of time. And the basic way they work is like this:

INDEX($E1:$E1405,MATCH(1,(W2=$C$1:$C$1405)*(X2=$D$1:$D$1405)*(AA2=$J1:$J1405),0))

(Note: All column and row designations here are arbitrary and made up, so they don’t matter.)

That might look complicated, but it’s not. Let’s break it down. The first part, referring to the E column is the “Where” of the formula. That is, this is the column you’re pulling your data from. For example, if you want to use size, color, and style to find price, then this would be whatever column has the price data in it.

Next, we nest the MATCH function, and this lets INDEX know that what comes next will be the instructions it needs. The “1,” inside the parenthesis is a flag for MATCH, telling it to return one value. After that, each nested thing — and you can have as many as you need — follows the form “Single cell to look at equals column to search.” So, as seen here, for example, in the search data, column W might be the first name, and cell W2 is the cell corresponding to what we’re looking at. Meanwhile, column C in the target data includes first names, so what we’re saying is “Look for the single value of W2 down the entire column of C1 to C1405. The dollar signs are there to lock it as a fixed range.

All of the other parentheticals here follow the same pattern. Maybe X is the column for last name in the source and D is where the last names are in the target; and AA is account number, as is J.

The two other interesting things to note in building matrix equations: The single cell and the column are joined by an equals sign, not a comma, and this is important because, without it, your formula will break. What this tells Excel is that whatever the matrix pulls out of single cell must equal what’s in the column at that point.

The other thing to notice is that between the searches within parentheses, there aren’t commas, but rather asterisks, *, which indicate multiplication, and this is the heart of Matrix math.

What this tells the formula is to take the results of the first thingie, apply those criteria and pass it along to the second. In other words, if the first evaluation turned up nothing, that is mathematically a zero, and so it would quash anything coming from the second and third functions. On the other hand, if it comes up as a one, then whatever the second formula turns up will stay if there’s a one, dump if not, and then pass on to the third, fourth, etc..

Lather, rinse, repeat, for as many steps down the process you’ve created. A false at any point in the matrix math will kill it and result in nil. Meanwhile, as long as the tests keep turning up positives, what will fall out of the ass end of it is the honest legit “This data is the true data.”

Funny how that works, isn’t it? The only other trick you need to remember is that after you’ve entered this formula, you need to close it out by hitting Ctrl-Shift-Enter to let Excel know it’s a matrix formula. Then, if you want to copy it, you can’t use the usual Ctrl-C, Ctrl-V. Instead, you have to highlight the column with the formula at the top, then hit Ctrl-D. Voila… the whole thing repeats down the column.

And there you have it — a way to search multiple criteria in a row in order to find a specific data point in a table. You’re welcome.

But there’s more! One very important trick I’ve learned is how to avoid getting the dreaded “N/A#” in your results, because that totally breaks any summation you’re doing on the data. So I add an extra layer to the whole thing with a combination of the IF() and ISERROR() formulas.

This can make the thing really long, but worth it. I suggest entering the short INDEX formula first, make sure it’s working, and then use F2 to edit the cell, highlight everything and hit CTRL-C. Next, add “IF(ISERROR(” before the existing formula, move your cursor to the end, close out the ISERROR with a right parenthesis, “)”, then add comma, 0, and hit Ctrl-V to paste a copy of the original formal at the end. Close that with a final right paren.

The whole thing looks like this:

IF(ISERROR(INDEX($E1:$E1405,MATCH(1,(W2=$C$1:$C$1405)*(X2=$D$1:$D$1405)*(AA2=$J1:$J1405),0))),0,INDEX($E1:$E1405,MATCH(1,(W2=$C$1:$C$1405)*(X2=$D$1:$D$1405)*(AA2=$J1:$J1405),0)))

Sure, it gets a little long, but the advantage will be that if what you’re looking for isn’t in the source data, you’ll get a nice zero instead of an error message. And if you’re searching a text field, like size or name, then use “” instead of 0 after the ISERROR.