Hi
Are you wanting to bring back a value and then declare it -ve or +ve, or do
you only want to bring back a -ve or +ve?

--
Andy.


"sansk_23" wrote in message
...
How do i get : e,g. only -ve or only +ve values when i do a vlookup on a
database table / array of data ?
Can this be somehow incoporated in the a single formula with VLOOKUP ? -
instead of retrieving the complete data first and then giving another
condition for getting only the -ve(s) or +ve(s).

Pls. help.

br, Sk.