Thread: Lookup
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Lookup

Do you have negative numbers in your table?

--
Don Guillett
SalesAid Software

"americasmattress8888"
wrote in message ...
I am currently using a lookup and when the number being entered a negative
amount the answer comes back as #N/A why? And what is the correct way to
fix
it?