To overcome this, you can add a helper column and concatenate the values from two lookup columns ( Customer and Product) there. A complicating factor is that each customer ordered multiple products, as shown in the table below:Ī usual VLOOKUP formula won't work in this situation because it returns the first found match based on a single lookup value that you specify. Suppose you have a list of orders and want to find the quantity based on 2 criteria, Customer name and Product. But what if you want to look up with several conditions? There are a few different solutions for you to choose from. However, it lacks an important feature - its syntax allows for just one lookup value. The Excel VLOOKUP function is really helpful when it comes to searching across a database for a certain value.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |