Excel Module 10 Case 1 Q6

I cannot understand the formula needed to come up with an answer that will work with a various numbers of attendees. The formula I came up with only works when the number of attendees is 0, 50,100,150, & 200.

Here is what I used: =vlookup(number_of_attendees,D6:E10,2,False)

 

6. The company must rent a conference room large enough to accommodate the number of attendees. The lookup table in the range D5:E10 contains the room charges for seminars of 0 to 50 people, 50 to 100 people, 100 to 150 people, 150 to 200 people, and beyond 200 people. For example, a room that fits 0 to 50 people will cost the company $400. In cell B23, calculate the room rental cost by looking up the room rental fee based on the number of attendees to the seminar. (Hint: Use the VLOOKUP function with an approximate match lookup.)