#xlookup

[vetendraeduworld]

Xlookup with Countifs function for freshers in Excel @VetendraExcel #exc...

[excelhelps]

HOW TO USE VLOOKUP & XLOOKUP IN EXCEL!

[gsheetsguide]

👋🏻 Now Say Goodbye to VLOOKUP!

Learn How XLOOKUP in Google Sheets Can Make Your Life Easier with 7 Examples

[underforeversgrace]

i've accidentally become the excel queen at my job and I have 0 regrets.

i still dont know what the fuck a pivot table is.

[leiflitter]

I am in Microsoft exHell

[ohbutwheresyourheart]

Monday work gripe of the week: my reasonably intelligent coworker who is the same age as me could not successfully copy/paste data from one excel sheet to another

[fuck-yeah-spreadsheets]

Do you ever just head into a spreadsheet that someone else has made and you're just like awwww yes, this is babie. Adorable, inefficient and error-volatile spreadsheets are so nostalgic.

Please let me fix it.

[naptimed]

so embarassed..... was drunk earlier and ended up spending 30 minutes struggling to make a google sheets formula w/ conditionals and regexmatch when all i needed was xlookup

[aamitmorthos]

head in hands i love taking 40 days and 40 nights figuring out stuff 👍🏾

[nimuetheseawitch]

I think that if people could be deified by the beliefs of others, my coworkers would've made me the patron deity of spreadsheets. Pray to me via email or IM and I will fix your formatting issues and broken references. My acolytes will share with all the wonders of XLOOKUP (or VLOOKUP in older versions of the holy texts) and IFERROR. Time started in 1900. Trying to consider dates before then leads to madness.

[intosnarkness]

i made a google sheet a work that took rsvps from our instructors who are agreeing to teach this year out of the system where they RSVPed

then it calculates a unique ID for them based on name and local union

then there are sheets broken out by course number (because each first number has a different person coordinating those instructors) and filled with the info we used to contact them. these generate the same unique ID from their name and local union

then i used if(iserror(vlookup script to pull over their rsvp, the email they entered, and any questions or concerns they had

and then i used conditional formatting to highlight anyone whose entered email didn't match the one we sent their invite to so we can update it in our system

and my boss took one look at this and said "you know no one else in our department can do anything even approaching this?"

so i texted my dad to thank him for teaching me how to do vlookups.

sincerely, if you are starting out in your career, learn how to make excel do a tiny bit of magic and you will go so so very far.

learn how to do vlookup, xlookup, if, iserror, countif, and sum and you'll be most of the way there. conditional formatting is annoying, but useful. pivot tables, if used correctly, might get you referred to the spanish inquisition. and VBA scripts! you can do so much stuff automatically with VBA. I use it every year to break our course evaluation master into individual sheets based on course and instructor. takes me 20 minutes instead of 3 weeks it would take doing it by hand.

you can get a lot of pre-written VBA code online as well, so as long as you know how to activate the developer console, you'll be fine. it's nowhere near as scary as you think it's gonna be.

learn excel. learn spreadsheets. you'll thank me for it.

[solemntitty]

as per usual the worst part of reports is figuring out 'the fuck do I exclude' and 'the fuck is this outlier'

oh not me procrastinating on my work and doing it the night before as if I'm still in college and have a midnight deadline

[takovanormalnielie]

3.5.2024

Před prací jsem si dojela znovu na odběry. Musím říct, že mají v naší nemocnici na odběrech skvělej personál. Pamatují si mě a jsou hrozně milí. Dneska mi má oblíbená sestřička/laborantka pochválila nehty a povídala mi o tom, jak má její manžel v armádě FtM kolegu. V práci jsem toho dnes udělala celkem dost a připadám si už docela samostatná. S jedním úkolem jsem si poradila trochu po svým a mazaně jsem využila XLOOKUP netradičním způsobem. Dysforie celej den bila na poplach, protože mám obličej sežehlej a plnej vousů, ale zvládla jsem to překousnout a byla jsem aktivní a komunikativní. Měla jsem asi ten nejlepší blbej den vůbec a to jsem se ho celou dobu děsila.

[monstrous-femme]

bored at the office job asks if you should choose to accept them:

do you have a favorite pen? and is your favorite pen your favorite writing implement for all circumstances or do you actually have situational favorites?

what is your favorite excel function? (i dont actually know how to use spreadsheets beyond very simple functions tbh but i'm pretty sure you've said you're an excel guy?)

is your desk neat or messy? do you keep any personal items/pictures/toys etc on it?

1. Not one specific favorite pen, but favorite type is gel pens only I am constantly losing pens so I usually have to use whatever ballpoint is around and they don't glide right

2. Xlookup truly is That Girl when it comes to excel because it lets you look up data from other places without having to directly link cells and makes it So Easy to work efficiently with data. I also love nested =IF statements for making specific things happen, it makes me feel like I'm coding once I get four or five of those bad boys together.

3. Messy messy messy. Currently on my desk are three notebooks, a broken keyboard, several random binders, trail mix that is now mostly raisins, bubble mix empty otoscope cases, and more! I didn't used to have toys in my office but my boss keeps giving me little trays of kinetic sand, usually when she doesn't have time to meet with me, which is very funny like "sorry I don't have time for you here's a toy" and I'm like oh boy! A toy?

Thanks for asking, that was fun!

[thatsuncleharrytoyouyoungman]

damn daniel ive been thoroughly spoiled by excel 365 bc i have to lookup values to see if they're missing in this sheet n it's a bummer to do manually so i was like ok my good friend xlookup will be handy here but woe be me the xlookup function isnt avail???? girl im going to cry

[patrice-bergerons]

Bruins players as Excel functions, sorted by usefulness and exactness of match

(you're not the only one bored at work)

the scream I let out when I saw this ask -- I love you

Bergy: =INDEX(MATCH). The bread and butter of all Excel functions. Beautiful, versatile, and powerful, it does two things at once (indexing and matching) and is there to defend your spreadsheet against all errors

Marchy: To us he is =AGGREGATE() which allows you to do all sorts of summary stats in a dynamic way, i.e., via ignoring any grouped out rows, subtotals, and crucially errors, much like the way we overlook his long history of questionable decisions LMAO. To the rest of the league, I am afraid he is a =VLOOKUP() with exact match set to FALSE, which is to say extremely unpredictable and annoying

Pasta: =XLOOKUP(). He is the super dynamic, powerful, next gen function what can I say?

The goalie tandem: =SUMIFS(). Man, the way they are joined at the hip, they are like two functions merged into one AND they keep the world turning -- where would we be without sumifs after all?

Zee: =LARGE() I could not help myself

This is all I've got for now but everyone is welcome to add more for the rest of the squad and I do take constructive criticism.