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
wrote:

Trying to create a formula that will do the following:

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