S
Susan
Trying to create a formula that will do the following:
If a1="1", then vlookup ...........or if A1="2" then vlookup......
If a1="1", then vlookup ...........or if A1="2" then vlookup......
G
Gord Dibben
Not enough information.
Vlookup what?
Where would this formula be entered?
Let's say for example we had Gord in B1
In C1 we enter =IF(A1=1,VLOOKUP(B1,table,colndx,false),"not equal 1")
Gord Dibben MS Excel MVP
Vlookup what?
Where would this formula be entered?
Let's say for example we had Gord in B1
In C1 we enter =IF(A1=1,VLOOKUP(B1,table,colndx,false),"not equal 1")
Gord Dibben MS Excel MVP
J
John
Maybe this ; =IF(OR(A1=1,A1=2),vlookup,"")
This is just a example : =IF(OR(A1=1,A1=2),VLOOKUP(B1,C1
12,2,FALSE),"")
You don't say what you want if no match, so I put "", this will leave the cell
blank.
If you put double quotes around your numbers, it will tell excel that those
numbers are text, not numbers.
HTH
John
This is just a example : =IF(OR(A1=1,A1=2),VLOOKUP(B1,C1
12,2,FALSE),"")You don't say what you want if no match, so I put "", this will leave the cell
blank.
If you put double quotes around your numbers, it will tell excel that those
numbers are text, not numbers.
HTH
John