Developer Forum

...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

Maybe this........

=VLOOKUP(C1,P:Q,2,TRUE)

Vaya con Dios,
Chuck, CABGx3

The below is using LOOKUP (not VLOOKUP)

=LOOKUP(C1,{0,1,1201,1801,2501,3001},{"","Company 1","Company 2","Company
3","Company 4","Company 5"})

If this post helps click Yes
---------------
Jacob Skaria

=VLOOKUP(C1,P2:Q6,2,TRUE)

If this post helps click Yes
---------------
Jacob Skaria

thank you both .. great help!