VLOOKUP to calculate IFs

M

Mayte

....I'm stuck on this one too ... anybody.. help?? I know how to use a vlookup
but i've never used it with IFs. I have to return a name from column "Q"
using a vlookup IF a value in column "C" equals the square ft range in column
"P"

I have a table for the lookup
Sq Ft (P) Name (Q)
0 Company 1
1200 Company 2
1800 Company 3
2500 Company 4
3000 Company 5

So...
- IF value in cell "C" between 0 - 1200, return name "Company 1"
- IF value in cell "C" between 1200 - 1800, return name "Company 2"
- IF value in cell "C" between 1800 - 2500, return name "Company 3"
- IF value in cell "C" between 2500 - 3000, return name "Company 5"
- IF value in cell "C" more than 3000, return name "Company 5"

does this make sense?

any help will be greatly appreciate it !!

cheers,
mayte
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top