Still using VLOOKUP? Here’s how INDEX and MATCH can provide a better solution. Excel spreadsheets are a great way to organize a large amount of information. However, scanning through that data to find individual records can quickly eat up your time. Fortunately, there are ways to speed up the process. VLOOKUP is many users’ go-to method when it comes to this kind of task. It’s quick, and it’s relatively straightforward, but it’s not as robust as other alternatives. By employing INDEX and MATCH, it’s possible to avoid some silly mistakes that can often arise while using VLOOKUP. Plus, if you’re dealing with a particularly...
Read the full article: Search Excel Spreadsheets Faster: Replace VLOOKUP With INDEX and MATCH
from MakeUseOf http://ift.tt/2q4kh8I
via IFTTT
0 comments:
Post a Comment