I have attached a simple template showing what I want to achieve, I have tried various functions to get the desired result.
Essentially, the returned value should be £27,000 by using the criteria in cell A3, finding it in the range H6:K17 and then returning the value in the range H5:K5.
Any help would be most appreciated.
Bookmarks