Hi Fellow Forum Users



I am looking for a complex formula perhaps using Index and Match to achieve what I need.

Basically I have a range of data comprising 7 columns by 7 rows (A3 to G10).

I want to search for two values in columns A and B and then return the Maximum value found between columns C and G.

Here is the formula that I have just tried:

=VLOOKUP(A3&"-"&B3,'Collated time'!A3:H9,MAX('Collated time'!D3:H9),FALSE)

When I use the Function editor the correct value is displayed in the Result area. However in the cell that contains this formula I get #N/A.

Any help would be appreciated.

Kind regards
Tony