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