Forum Discussion
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/XL
Many thanks for your help!
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.
3 Replies
- 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.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.
