Enter a nested function in cell B$2$ using INDEX and MATCH to find the expected delivery date for the item listed in cell B$1.$ Use the named range JunePOs to reference the cell range INDEX Arroy argument. The expected due date is in column $5.$ In the INDEX Row$\_$num function argument, use MATCH to look up the row number for the item listed in B$1.$ Use the named range POitems as the MATCH Lookup$\_$array argument. Require an exact match.

Inventory List