Hi All
I am trying to do a vlookup, but only if it matches another condition, ie, not just bring back the first value it finds whilst descending. If you look at the example attached, I want to bring back a price against the item #, but only the price that also matched the customer. Hope this makes sense!
Cheers
Bookmarks