software

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 =g1amp;h1amp;i1amp;....
in another sheet I have put, the query and at the bottom I have
=a1amp;a2amp;a3amp;...
when these great great;
I would like to get a match or the next highest number from column g
thanks
AndyI 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 quot;get
a match or the next highest number from column gquot;. Can you give some more
specifics?

quot;dmexcelquot; gt; wrote in message ups.com...
gt;I am trying to find a way to do this:
gt; I have multiple contitions(5) so to get a match I have put the cells
gt; together such as =g1amp;h1amp;i1amp;....
gt; in another sheet I have put, the query and at the bottom I have
gt; =a1amp;a2amp;a3amp;...
gt; when these great great;
gt; I would like to get a match or the next highest number from column g
gt; thanks
gt; Andy
gt;
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