XMatch Function in Excel

Описание к видео XMatch Function in Excel

This video shows how to use the XMATCH Function in Excel to search on a numerical lookup value and find a value equal to or the "next largest or smallest" value in a lookup array.

This illustration begins with future sales projections by month in a vertical list. This example utilizes the XMATCH Function to the find the point at which the future projections clear $100,000.00 in sales.

Комментарии

Информация по комментариям в разработке