Vertical search. Finds a key in the first column of a range and returns the value of the specified cell in the found row.
Microsoft Excel's VLOOKUP function performs a vertical lookup on a value in the first column of a table and returns values from another column in the same row of that table. The VLOOKUP function can find exact matches in lookup columns. B. Returns the product code and price. The VLOOKUP function searches for specific values in your data, and once you locate that value, you can find and display other information associated with that value. Select the area to search before pressing Ctrl+F. For example, if you want to limit your search to a specific column in your worksheet, select that column before displaying the Find tab of the Find and Replace dialog box.
Learn more about column here-
https://brainly.com/question/3642260
#SPJ4
