Problem:
There is a table. Column A:D are mapped to column E with unique records. In a new column (Q), there is a list of values that that contain any randomized value from Columns A:D. What is the syntax to map Column Q to column E?

Is using INDEX/MATCH the right direction?

My H1-B expires on April 2022. My perm is currently in process and they are applying for H1B extension and H4 visa extension for my spouse. The immigration team said that they can apply for an H4 ead as well. Is that possible? My H1b visa started April 2016 on i-94 and and is stamped as start date April 2016. I have only been physically in the US for 5 years and 2 months. I am confused on how can they still file for an EAD? Am I missing something?

Any technology consulting companies that are willing to sponsor a skilled worker visa in the UK? (excluding big 4)

EY (specifically the New York FDD data analytics team) is actively hiring seniors and managers. Please feel free to reply to this post or send me a private message if interested. Thank you!

Anyone wants to take the expert certification exam?

Hello Guys,

Can anyone help me with a referral? I see many positions opened matching my skill set, but not getting a call.

Anyone getting paid well with full remote optical engineer positions? Niche I know but

Are there any fundamental differences between a salary negotiation during the start (applying for the job) vs. Salary negotiation during a performance review (you’ve been employed for x time and looking for a raise). I’m in the latter and wondering if there are any maneuvers that are different I should be doing.

Hello, any .net developer here? Need some info.
Thanks in advance.

What are your thoughts on Trump’s executive order suspending immigration to the US for 60 days?

What's the leave policies in EY GDS!? Can someone shed some light.

Going to Chicago with wife July 4 weekend (both are 25 years old). Any recommendations on holiday specific events?

Any other must eat spots besides deep dish?

How to handle the dual employment in BGV? I have a friend who have a overlap of 30-40 days from his last organization which is not disclosed in CV and with current organization. I feel UAN check will spoil it but his overlap is cuz he wasn't able to return assets back during COVID. Any suggestions?

Best store to buy a nice watch? Male/$1000 budget

Opinions on Alvarez & Marsal on cybersec and privacy ?

Within a year of making Manager, but I want to move to M&A. Should I stick out another year or move now.

Anyone hit a manual on how to do EVERYTHING in excel 😭? PDF or something

Need to create an P&L for a physical therapy center without using existing excel templates. Just cap payment info, lease price, team member salaries and supply costs.

Seeking formula support…,and open to other tips and tricks.

Our group is exploring Alteryx. When I review im Excel, I can click on a cell to verify the formula. In Alteryx, I will get a hard coded Excel sheet. What are some ideas to make Alteryx reviewable?

Is there a way to add 3+ criterias into a vlookup and if there are multiple results, to list them in different cells?

Right click menu. If you have a Logitech keyboard with no key to access the right click menu, press FN and F10 to pop open the menu. Very handy when you are trying to lose the mouse.

What's the equivalent to a sumifs formula but instead of #s I want to bring in names. For example, i want to return a client name but only if it meets two criteria.

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.

Story time: I was on a trip about 15 years back, doing some Excel work on a ferry ride - your basic pseudo-database work that is so common. I started talking with the guy sitting next to me and after a while he commented on what I was doing, “You know, that’s really not what I designed that for…” (continued)

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

To see a list of all tabs you right click on the arrows to the left of the tabs. Is there a shortcut to this without a mouse?

Anyone know of any roles or companies that hire you with basic excel skills and train you in advanced excel/analytics?

What is one excel command that is faster if you use a mouse?

Feeling behind at work. I’m relatively new to data/financial modeling. Any advice on learning how to take a client data set, cleaning it up, and turning it into a model for analysis? I’m a new consultant at a boutique and I’ve basically received no training at my company on how to use Excel to do this. Additionally, is this fair game for a new analyst to understand how to do this without any prior training?

Would someone please explain in a simple way when to use an array? Is it for every index match formula every time?