Look up table question
What is the range (Columns/Rows) of your "Value Table" and is it named
Costing?
"whohasmynameuk" wrote:
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
|