Categorization and Vlookup

[Einsjam]

I have to categorize each restaurant size as ‘Small’, ‘Medium’, ‘Large’ or ‘Really Big’ according to their ‘Annual Store Sales’ by using the following table.

Annual Sales Levels Size Label
Less than $1,000,000 Small
$1,000,000 and more Medium
$2,000,000 and more Large
$3,000,000 and more Really Big

Here's the file

Data.xlsx

How to use Vlookup function to resolve this ?

[ajryan88]

Hi,

Is this what you wanted?

[oeldere]

Is this a homework question?

See the attached file.

In N3 (green cell) you find the result.

Please reply.

[Einsjam]

Yes, but i ned to do according to these instructions
Use ‘Restaurant Size by Sales’ column in ‘Information’ worksheet to categorize each restaurant size as ‘Small’, ‘Medium’, ‘Large’ or ‘Really Big’ according to their ‘Annual Store Sales’ by using the following table. (You need to use VLOOKUP function for this; and the table needs to be stored in a new worksheet: ‘Size Table’)
Annual Sales Levels Size Label
Less than $1,000,000 Small
$1,000,000 and more Medium
$2,000,000 and more Large
$3,000,000 and more Really Big

[Einsjam]

Is this a homework question?

See the attached file.

In N3 (green cell) you find the result.

Please reply.

Thanks mate :D

[oeldere]

@ajryan88

Tip:

You can better make an table of that data (like I did)
(of course this is an personal opinion).

Why:

1) if you have more than 7 options you won't be able to make this formula in an Excel 2003 environment

2) it is much easier to change if, if the criteria changes

[oeldere]

@Einsjam

Please answer the question, Is this an homework question?

[Einsjam]

yes this is a homework question, and I didnt understand the VLookup function, i knew how to use the IF statement to categorize, but the teacher had specifically asked to use the Vlookup function

[ajryan88]

Thanks oeldere! Of course, the approximate VLOOKUP. So obvious in hindsight!

[oeldere]

@Einsjam / ajryan88

Thanks for the reply,

Glad I could help.