Excel VLOOKUP: Retrieving Data for Ranges

Vlookup For A Range

Your task:

Your company set the new targets of sales. If employee reached the target, he will get a bonus. The higher target is the higher bonus. Let’s calculate the bonus using vlookup function.

Your formula looks like below:

=IFNA(VLOOKUP($C2,$A$2:$B$6,2,1),0)

Explanation:

C2 – here is the lookup value

A2:B6 – this is a whole range of data (table_array)

2 – number of column in the range

1 – stands for approximate match

IFNA – this function checks if there is some bonus. If not it writes $0.

Template

Further reading: 
Basic concepts 
Getting started with Excel
Cell References