Prev: Blank cells not to compute
Next: If word from list selected adjoining cell to downfill with a code
From: Susan on 2 Jun 2010 22:19
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 2 Jun 2010 22:34
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 3 Jun 2010 08:47
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......
>
>

 | 
Pages: 1
Prev: Blank cells not to compute
Next: If word from list selected adjoining cell to downfill with a code