Using the IF funtion on the VLOOKUP result

[sturnusek]

Hi there,

I came along this little annoying problem, yet is seems so simple. I have a VLOOKUP in place to return me a value, it could be between 0 and whatever. Then I used a simple

=IF(P2>0, "Positive", "Negative")

to make a statement about the return, but it doesn't react to anything. I tried it on normal numbers (not VLOOKUP results) and it works just fine.

Any ideas?

Thanks

 

[gaz_chops]

Hi, is the result of the vlookup actually a number?

Gaz

 

[oldbrewer]

=if(vlookup(a1,D1:D15,2)>0,"pos","neg)

 

[Fluff]

is the vlookup returning an actual number or a text value that looks like a number?

 

[sturnusek]

It's returning/pulling an actual number

Thanks oldbrewer, that's one way to do it.