View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
whohasmynameuk whohasmynameuk is offline
external usenet poster
 
Posts: 4
Default Look up table question

I am using this look up to insert a cost into column I from my value table.
how can i get a description inserted into Colunm P of my spreadsheet. I tried
changing costing to discription but it just gave me #name

=IF(I13<1,"",VLOOKUP(I13,Costing,2,FALSE)*J13)

thanks