Problem with vlookup, need a 3 column range lookup, ?

[RubinaTT]

=VLOOKUP(E2,'Fee Allocations'!$A$2:$D$6,IF(W2<=2,2,3),FALSE)

I am using this formula and am needing to add another range (column), but it
will not let a range work in the formula , IF(W2<=2,2,3,4),FALSE) Can the
formula have 3 column?

 

[kassie]

What criteria do you want to use for the "third column", or then the 2nd IF?
=VLOOKUP(E2,'Fee Allocations'!$A$2:$D$6,IF(W32<=2,2,IF(<what criteria>,3,"")))

 

[Charlie]

Have you solved you problem yet?

For a multiple column lookup you need to use a combination of the =Index & =Match formulas.

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com