Hi All,

I have a couple of spreadsheets where i have stock items, prices, wattage and supplier etc... I have used the name manager to create a database of the information (IDB) and a spreadsheet i use for costings. when i use this formula: =DSUM(IDB,'[Kit List.xlsx]Sheet1'!$G$5,D$4:D5) it works on the prices (dsum) and when it looksup the product with the heading (D$4:D5) then looks at the database with the header (IDB,'[Kit List.xlsx]Sheet1'!$G$5) and retrieves the relevant info... price, wattage etc. but now i have added in a supplier so i know who it was bought from. the problem is instead of a supplier name its retrieving a figure?? i pressume its something to do with dsum but i dont know what else to put there to have it retrieve the name instead.

Thanks in advance for any help