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,"")))
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error 9 - subscript out of range 1
vlookup returns the formula I entered, not the expected value 1
Need VLOOKUP to Work Two Ways 0
Extremely slow calculation of formulas 4
Using VLOOKUP to locate an answer in one of multiple columns 1
Vlookup error 1
VLOOKUP returning #N/A result 2
Vlookup with multiple FOR condition 1

Back
Top