Hi
I am looking for a formula that will search a separate worksheet for a value on the current worksheet and return the maximum value from a range on the same row that the searched item is found. I have tried various formulae but for some reason I am stuck.
Any help would be appreciated.
Thanks in advance.
Tony