There are several functions in Excel that allow you to help select data based on certain criteria. VLOOKUP and INDEX/MATCH are two such functions that are widely used, but one lesser-known function that can help you with the same is the CHOOSE function.
from MakeUseOf https://ift.tt/lw8vN1F
Tags
News