Vlookup inside an IF - Is this possible?

[JennyW]

Hi.

I'm trying to nest a VLOOKUP inside an IF statement, but I'm having A LOT of trouble.


Here's my function (which doesn't work):

=IF((S5=12),0,VLOOKUP(T5,JennyTest,2))



What I'm trying to do is the following:


If S5=12, then input 0 in the cell, if not, then run the VLOOKUP.

My result is I keep getting a "1".



Does anyone know what I can do here?


Thanks!

[daddylonglegs]

Well, it's a totally viable formula, but I presume you don't expect 1 as an answer....

Your VLOOKUP has no 4th argument. This means the lookup range, leftmost column of JennyTest, has to be sorted ascending. If you want an exact match only from VLOOKUP and your lookup range may not be sorted then use a 4th argument of zero, i.e.

=IF(S5=12,0,VLOOKUP(T5,JennyTest,2,0))

[JennyW]

Hi daddylonglegs and others....!!

Unfortunately, that didn't work either........I still received a result of 1


Eeek!

[daddylonglegs]

Well, I suggest you need to break it down.

What's in T5?

What range does JennyTest represent?

Where's the first occurence of T5 in the leftmost column of JennyTest.

What value is in the corresponding cell in the next column?

edit: or is S5 = 12?