thanks for reply
i tried the fomula below
it errors on the dollar sign
if i remove the dollar it returns N?A

On 22 Jul, 11:17, "Bob Phillips" <Bob...@somewhere.com> wrote:
> Isn't it just
>
> =MAX(VLOOKUP($10,B6:C56,2,FALSE),VLOOKUP(10,B64:C1 13,2,FALSE),0)
>
> --
> __________________________________
> HTH
>
> Bob
>
> "kevin carter" <kevca...@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- Hide quoted text -
>
> - Show quoted text -