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

I see you are concatenating information together to find when multiple
events occur. I'm not clear on what you mean when you say you want to "get
a match or the next highest number from column g". Can you give some more
specifics?

"dmexcel" wrote in message
ups.com...
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

Oh sorry about that,
For this example column G would be an amount, all the other numbers
would match but if column G doesn't match, is there another row that
has the same criteria but more.
Basically, is there another pile I can grab from?

Oh sorry about that,
For this example column G would be an amount, all the other numbers
would match but if column G doesn't match, is there another row that
has the same criteria but more.
Basically, is there another pile I can grab from that meets all the
other criteria,
Also, would need to return a stock number from another column.
I have this in VBA, but it only works for one search, I need this to
work six times, so I am looking for a formula that I can copy to
another column but use the stock list.
What is happenning is this,
A new order gets written up that can involve up to six items, as the
specs are being inputted there will be a search to see if we have an
item in the yard.
if there is a match or if there is another item that we can cut off
from,(example: we need 12 feet at these specs all we have is 13ft, we
can cut a foot off the 13)
A message will show up on the production papers, telling the forman to
check the yard for this item before manufacturing it.
andy