166k views
2 votes
Susan is in charge of the inventory reports for her company.She will need to find specific inventory items as well as project increases in inventory costs.To get ready she will create a worksheet and use the Microsoft Excel 2016 Analysis tools.Susan designs a worksheet with the inventory number, description, quantity, unit cost, reorder point and value.To find values in tables of data, and insert them in another location in the worksheet such as cells or in formulas, she will use ________

User Irudyak
by
5.4k points

1 Answer

5 votes

Answer:

lookup function

Step-by-step explanation:

We can use the lookup function to find some values or reference in a range, we can use this syntax: LOOKUP( value, lookup_range, [result_range] ), where value is what we are going to look for, lookup_range is the single row or column is the range, and result_range is an optional part, in this range we're going to get the value.

User Roi Tal
by
5.9k points