From: Susan on
Trying to create a formula that will do the following:

If a1="1", then vlookup ...........or if A1="2" then vlookup......


From: Gord Dibben on
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


On Wed, 2 Jun 2010 19:19:31 -0700, Susan <Susan(a)discussions.microsoft.com>
wrote:

>Trying to create a formula that will do the following:
>
>If a1="1", then vlookup ...........or if A1="2" then vlookup......
>

From: John on
Maybe this ; =IF(OR(A1=1,A1=2),vlookup,"")
This is just a example : =IF(OR(A1=1,A1=2),VLOOKUP(B1,C1:D12,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
"Susan" <Susan(a)discussions.microsoft.com> wrote in message
news:79EB3AC0-3129-4B88-9FF9-F6B90B6E965B(a)microsoft.com...
> Trying to create a formula that will do the following:
>
> If a1="1", then vlookup ...........or if A1="2" then vlookup......
>
>