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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=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?
 
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,"")))
 
Back
Top