Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Clean Inventory with Nested IF and VLOOKUP

Medium
SQL & Data Manipulationnull handlingData WranglingperformanceAsked 1 times

Problem

Walk me through how you would use a nested IF statement combined with a VLOOKUP to clean a mismatched inventory dataset at Zulily.

Practicing as: Business Analyst interview at Zulily

Hi, I'll play your Zulily interviewer for the Business Analyst role. Candidates describe these interviews as mixed and moderately difficult, so expect me to be professional and fair. Take your time with the question above and answer like we're in the room.

You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.

Sign up freeI have an account
Sign up to unlock solutions
Zulily Business Analyst Interview Questions
Next questions
New BalanceClean Inventory Data with ExcelMediumAvnetReconciling Inventory with LookupsMediumCelesticaReconciling Conflicting Inventory SheetsMedium