I couldn't find the answer to this in the forums so I'm posting it. I need to do a search for a value in column a and return the value in column d. I tried using vlookup but sometimes there may be multiple matches, if so I need to add them all up and place that value in a cell in a different worksheet. Here is what the data/spreadsheet looks like:
Worksheet2:
colA colB colC colD
/u110 john sunday 100000
/u123 may tuesday 189376
/u110 joe saturday 2390000
So if my search finds /u110 I want it to return both values from colD, add them up and return those results to a cell(A1) in Worksheet1.
Bookmarks