Im trying to use a look up f(x) for a list of names recieving funds from multiple sources. They arent working every day so we have a drop down list set up to only select the runners for that day. The weekly totals page has all their names and how much they did or didnt make for each day. Vlookup has failed me. It appears to be finding the closest match for everyone and returning the same total for the first guy on the list...example attached. Any ideas?
Bookmarks