alexsalovve
New Member
Help!!!!I have a database in excel of our clients and I need to get our sales team to update clients details, I am trying to create a sheet that I can print out with each customers current details but can only get it to pull through the figures using:=SUMIF(Sheet1!A2:A369,CurrentSheet!C13,Sheet1!C2:C369)Basically if cell C13 from my current sheet is listed in Sheet1 A2 to A369 show me what is in column C for that row!This work perfectly for figures but not text Can anyone help what I need to do to this to make it drag through text?