I am trying to find a way to do this:
I have multiple contitions(5) so to get a match I have put the cells
together such as =g1&h1&i1&....
in another sheet I have put, the query and at the bottom I have
=a1&a2&a3&...
when these great great;
I would like to get a match or the next highest number from column g
thanks
Andy