Question

enter a formula in cell b3 using the vlookup function to find the meaning for the medical abbreviation listed in cell a3. use the named range abbreviation for the lookup table. the item names are located in column 2 of the lookup table. be sure to require an exact match.
use this sheet to lookup medical abbreviations. enter the abbreviation in cell a3.
abbreviation meaning latin origin (if any)
abcd
abbreviation meaning latin
a&ox3 alert and oriented to person, place, and time
a&ox4 alert and oriented to person, place, time, and circumstances (often used interchangeably with a&ox3)
a&w alive and well
a.c. before food, from latin, ante cibum

Explanation:

Step1: Write the VLOOKUP formula structure

The VLOOKUP function has the syntax VLOOKUP(lookup_value, table_array, col_index_num, range_lookup). Here, the lookup_value is A3 (the medical abbreviation we want to look up), the table_array is the named range Abbreviation, the col_index_num is 2 (since the meanings are in column 2 of the lookup table), and the range_lookup is FALSE (for an exact match).

Step2: Construct the formula

So the formula in cell B3 is =VLOOKUP(A3, Abbreviation, 2, FALSE).

Answer:

=VLOOKUP(A3, Abbreviation, 2, FALSE)