Answer :
Answer:
=VLOOKUP(A11,A5:B7,5,TRUE)
Explanation:
The syntax of VLOOKUP is:
=VLOOKUP(Value to look up, cell range, number of cells to check, returned value)
In this case:
Value to look up = A11
Cell range = A5:B7
Number of cells = 5 ---- this can be any number, but make sure it is large enough.
Returned value = TRUE --- this can be any value; such as 1, 0, FALSE, TRUE.
So, the formula to enter in B13 is:
=VLOOKUP(A11,A5:B7,5,TRUE)