Forum Discussion

enthusiast_guy's avatar
enthusiast_guy
Copper Contributor
Feb 25, 2023
Solved

Frequency and categorizing

Hi all, I'm a bit stuck and would appreciate getting some help. The assignment is as on the screenshot. Categorize the rooms by the number of their chairs, and put the right label on." S/M/L/...
excel
Excel for web
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Feb 25, 2023

    enthusiast_guy 

    Let's say you create the lookup range from my first reply in G2:H5 (with headers in G1:H1).

    I think you want the formula in D2 and down, not in E2 and down.

    In D2, for example:

     

    =VLOOKUP(B2, $G$2:$H$5, 2)

     

    Fill down. The link in my previous reply explains the syntax of VLOOKUP - take a look so that you'll be able to understand how it works.

HansVogelaar's avatar
HansVogelaar
MVP
Feb 25, 2023

enthusiast_guy 

I'd create a small lookup range with threshold values:

You can use a VLOOKUP or XLOOKUP formula to look up the room size from the number of chairs.

(Since it is a homework assignment, you should try to work it out yourself)

enthusiast_guy's avatar
enthusiast_guy
Copper Contributor
Feb 25, 2023
First, thank you for your fast and specified answer.
I think I still haven't got it.
The goal is to write on Cullom E, which is which, according to the values.
Care to guide me through your way of solving it?

Again - I truly appreciate it; thank you.

Resources