I'm trying to use a lookup function to coincide with a sumif function. The data are in columns and I would like to have a formula lookup the text value in the column based on the input field. I've tried lookup, hlookup, vlookup and dget but none have worked for me.
Thanks in advance for your help.