View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
pinmaster
 
Posts: n/a
Default Vlookup and "-" negative numbers are giving me a #N/A

What's the last parameter of the VLOOKUP? If you're using TRUE or 1, then
your table might have to be sorted in ascending order, negetives to
positives. Or maybe your looking up values with decimal places that are not
showing.

HTH
JG

"DMB" wrote:

How do I deal with the negative numbers? If possible I would rather not
complicate my formula with an If statement.

Thanks again and again and again and again and again