Question

A manager needs to identify some information from the purchase orders database but has only has the order number. Modify the excel file to use the VLOOKUP functions to find the item description and cost per order for the following order numbers Aug11008, Sep11023, and Oct11020.

Answer 1

use vlookup on the table or columns or cell ranges that have the order number, item description and cost per order.

=vlookup(value to lookup, table, the value you want )

syntax:

=VLOOKUP(search_key, range, index)

Explanation: In my example, I use the above syntax in cells g2 and g3 and point the search_key(value to lookup) to the cell above G1 so that I can lookup the order numbers in the table that is to the left. The values are then populated in cells G2 and G3

I have attached this exam as an open office spreadsheet.