Tables consist of the columns “Product ID” and “Product Description”. In the range B2:C7 we have a table from which we want to pull data, while in in the cell F3 we want to get a value. In this example, our data is organized vertically, so we will use the VLOOKUP function. Data that we will use in the VLOOKUP example Setting up Our Data for the VLOOKUP Functionįigure 1. ![]() This means that we want to find an exact match for a lookup value.
0 Comments
Leave a Reply. |