Thread: Lookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
americasmattress8888 americasmattress8888 is offline
external usenet poster
 
Posts: 6
Default Lookup

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?