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

Hi Tony,

Can you attach a workbook to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul
Many thanks for your response. I have just resolved my issues with help from a colleague.
Many thanks.
Tony