Use the INDEX and MATCH
functions together, to find values in a lookup table.
The MATCH function
usually returns the row number for a specific item, but in this example, there
are two criteria. For example, find the price if Jacket is the item and the
size is Large.
This video shows how a simple INDEX / MATCH
formula works. Then, the formula is changed, to work with multiple criteria.
Simple formulas on the worksheet show why the MATCH function can find the
correct row. Visit my website to get the sample file. This is Example 4 in the
sample file.
Excel Tricks : Easy Technique To Replace Vlookup With
Index and Match Functions || dptutorials
Are you still using Vlookup? This Microsoft Excel tutorial will teach you how to use the INDEX and MATCH functions, which can provide a better solution. Click this link to download the discussed Excel file: https://drive.google.com/file/d/1vG9C... For Personalized detail learning, write to dptutorials15@gmail.com If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later.
No comments:
Post a Comment