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




"Mayte" wrote:

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

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


"Mayte" wrote:

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

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

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


"Mayte" wrote:

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

thank you both .. great help!