Need some urgent help with using if and vlookup together. Anyone willing to help via direct messages please?

like
Posting as :
works at
You are currently posting as works at

What exactly? I always try to use index/match rather than if/vlookup...

likehelpful

Agreed

like

Without knowing your problem it’s hard to say, but for weird “if” things it’s worth knowing how to use array formulas.

like

delegate it

like

Z sf ppl p9ll9lp0poo

helpful

Sure

Hmu

Related Posts

I'm struggling to find a good cafe to WFH at, that isn't incredibly loud all the time 😭

like

Hi, I got OL from CTS. As BGV shows 50%, Onboarding pass was not generated and DOJ passed. Haven't received any information regarding the next step. Tried mails and calls, no response yet. Will the HR team provide new DOJ?

like

Arrived to the hospital 30 minutes before a drug free vaginal delivery and checked out 24 hours later.. $18,000 for me and $3,500 for the new guy 🤯 🇺🇸

like

Do copywriters typically go on shoots? And what role does the copywriter typically play when they do go? I’ve had inconsistent experiences.

Our Data and Analytics practice is hiring, DM if interested!

likefunny

I have been an HR assistant for 2 years in the public sector 80% staffing 20% recruiting, I want to break out into the private sector and have 5+ interviews but never seen grab there attention. Recruiters have told me that I interview well, Any Advice?? I have also gotten a Hr management Cert and working on my PHR.

like

Can any one help me to learn SAP SD . I am from sales profile having 6 YOE. Trying to get into IT profile.

like

Diversity is something that BBs have been pushing in recent years, but how well has it actually been executed? How diverse is your group and do you feel like diversity recruits are treated the same?

like
like

Fish that have given 2 weeks notice in a sales role: when you gave your notice did you stay on for the full time, did you get walked with pay or walked without pay?

like

Anyone working at Xavient Digital, Noida??
How is it? Good for long term? My friend has an offer.. 7 yr Exp 23L CTC. App support engineer.

like

Hi!Please I’m looking for scrum master or business analyst roles.. I’m interested if you have any opportunities in your companies

DM me for below refferals

Post Photo
like
like

Looking for current salaries for acute care dietitians in the NYC/metro ny area. I've been in my position as an inpatient RD for 9 years and our RD salary is (I believe) at the lower end of the usual range for clinical care (especially with 9 yrs + experience). The RDs are going into contract negotiations in 2023 and just want some good ammo

like

Does Capgemini give training to lateral hires ? - Associate Consultant is the Designation.

like

Senior level folks who moved to A&M from Big4 - how do you feel about the approach to sales and sales targets at A&M ? Are sales generally network driven or do you feel you’re on your own to source clients/new projects ?

like

Hello Fishes,
I got an opportunity from NTT Data BPO.
I am currently being hired for nightshift. Are there any chances for getting day shift or mid shift?
Or are there any chances to get a change in shift after getting on boarded?
Will it be okay to discuss this with HR?
Because during interview I said yes to Night Shifts.

like

Hi fishes !! I’m going to join at Bangalore location, by when can I apply relocation to Gurgaon in ey , is this easy process or difficult??

like

Binged: STATELESS on netflix.
Cate Blanchet-produced miniseries based on true stories about refugees housed in an immigration camp. Thought it was very well done. Any other watchers?

Additional Posts in Excel Genius

Hi! I have knowledge of pivot tables, vlook ups. But I'm rusty on if statements and would like more knowledge on excel formulas. I'm looking for excel classes to take online. Any suggestions?

like

Tips on adjusting to Mac? I’ve figured lots of keyboard shortcuts but it’s just not the same 😪

like

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

like

What are the most typical models you all build

likehelpful

Can you share the most useful formulae and built in automation features you have used with the latest version of excel?

like

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

Last cell question. Some of my simple models are massive in file size because every tab has a last cell of ~XFD65. But I’m not using anything past ~U100. Continued.

like

Is there a way to consolidate non numerical data from multiple excel sheets into one master sheet?

like

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

Whats a good book/course that will teach me advanced excel skills? I want to be quick with shorcuts etc & learn VBA/Macros. Under $30 please, input is greatly appreciated.

like

What are the most annoying things for you in old-school excel users?
I’ll start:
1) vlookup 2) concatenate 3) inability to work with file versions, therefor constantly locking file from changes

like

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

I have a field in excel that represents the GSID, that I want to concatenate to create a link. Example field GSID is 123-west and the link needs to be www.website/123_west.html for some reason using concatenate with left & right formulas to switch - to _ results in the field throwing an error. Anyone knows of a way to make this work?

like

What's the F4 analogy in Office 365?

like

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

Hey, tips for where to look for good excel cheat sheets online? :)

What is y'all's preferred clipping tool? One of my former companies had a great simple program that was only like $50 and worth every penny.
Snipping Tool just ain't cuttin' it (lol pun intended).

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal