Need a formual

  • Thread starter Thread starter onemagicman
  • Start date Start date
O

onemagicman

Help - I have tried this with vlookup and match. For some reason I just
can't make it work. Here is my senario:

I am in the parts business. I need to compare inventory numbers
constantly against sales. I will keep this simple. In column a1:a5 I
put the following values: 1515,1516,2020,1034,1556. All valid parts
numbers. In another column I want to put in numbers but not in any
particular order. I want to be able to record hits. If I put in the
"B" column a number from "A" I want a return argument that the
spreedsheet has found a "match"

The real life use is for hundreds of numbers in two columns. Here is
the what if:

"A" is a list of inventory numbers from the shelf. "B" is a list of
known items which have sales movement. Match the numbers and tell me
which numbers are dead movers and should be pulled out.

Someone please bail my +_)(*& out on this so I can get back to work.
Thanks in advance.

Bill
 
I think you want the =Match() function:
=IF(ISNUMBER(MATCH(B1,$A$1:$A$5,0)),"match","nope")

I'm not sure if this fits your situation, but if you put that giant list on a
different worksheet, it might make it more useful later on.
 
Bill

Another way might be to use Excel's Data function. Set the
data like this:
1515 Part
1516 1515
2020
1034
1556


Date Part
02/02/03 1515
03/02/03 1516
04/02/03 2020
05/02/03 1034
06/02/03 1556
07/02/03 1515
08/02/03 1516
09/02/03 2020
10/02/03 1034
11/02/03 1556
12/02/03 1515
13/02/03 1516

Choose the Data Menu, Filter, AdvancedFlter.
The criterion range is B1:B2 (Note that it includes the
header)
The range is from A8 to ???
Click the Filter in place option and this will show all
the data records that meet the criterion.

Choose Data, Filter, Show All to remove the filter.

Regards
Peter
 
Back
Top