FOAK : Another Excel Question......

Column a consists of a list of 2000 or so 6 figure part numbers consisting
of numbers and letters e.g. 194220 19A217 etc.

Column C contains a list of 200 similar part numbers.

How do I find out if any of the numbers in column C also occur in column A ?

 

VLookup IIRC

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=446

 

Yep VLookup
simple version of how it works can be found here
www.naldernet.plus.com/holding

 

In column D, row 1
=VLOOKUP(A1,C$1:C$200,1,FALSE)

Copy that, and paste that in down to D2000, or wherever your Column A
figures run out. It should return the value in A wherever there is a match
in column C, otherwise it will return "#N/A".

There's probably a neater way to do it, but that should work.

 

correct.
Insert a new column B and fill the colum with something like "yes" in
every cell.
go to any availble column, let's say, D.

In Cell D1 enter: =VLOOKUP(C1,A:B,2,FALSE)

The formula looks at C1 and seeks a match anywhere within columns A and
B - if it finds a match, it returns the value in column 2 of the
selected range ie column B - "yes". If it does not find a match, the
response is #N/A.

There's a similar example I did for Ben Blaney here:
http://www.clogish.nl/BB/Ben_Blaney.xls

 

Dan White wrote

Command line scripting?

 

That would be the neater way I was referring to

 

Thanks as ever; one and all - VLOOKUP worked a treat.....

(I must get myself on a decent access/excel/sql course in the next year or
so).

Ta.