Step1: Create a separate column where we will create unique lookup_values by merging our two lookup criteria – name and country – for example “ MellaThailand“, “ MellaNigeria“, etc.You can’t specify two lookup values in a VLOOKUP formula, so we’ll need to use a workaround, which consists of two steps: So, we need to narrow down our lookup using two criteria: The issue is that we have multiple users with the name “ Mella“. Our purpose is to look up a car value for a user with the name “ Mella“, and the Excel VLOOKUP function can do the job easily. Read more about Microsoft Excel integrations for data export on a schedule. We imported a dataset from Google Sheets to Excel using Coupler.io, a solution for automatic data exports from multiple apps and sources. Step2: VLOOKUP formula for two values How to VLOOKUP for two values
0 Comments
Leave a Reply. |