Isn't it just

=MAX(VLOOKUP($10,B6:C56,2,FALSE),VLOOKUP(10,B64:C1 13,2,FALSE),0)

--
__________________________________
HTH

Bob

"kevin carter" <kevcar40@btinternet.com> wrote in message
news:77b0879c-a548-4715-b069-c9f2495b2f52@z66g2000hsc.googlegroups.com...
> hi,
> i have a spreadsheet containing 2 grids of data relating to an op
> the grid range for grid1 is B6:bb56
>
> grid 2 is B64:BB113
>
> in a third grid i have this formula
>
> (MAX(VLOOKUP($B$6,R6:R56,2,FALSE),VLOOKUP($B$64,R6 4:R113,2,FALSE))),0)
>
>
>
> i am trying to search a column for a fault ie op 10 which is in colulm
> B in both grids,
> when i find the match in both grids i want to look at a range of
> cells and compare
> the values in the cells and return the largest
>
>
> any ideas
>
> thanks
>
> kevin
>