duplicates; finding entries in column A which match any of column C entries

Hello! I'm new here and with excel functions in general too. What I need to do is sort certain entries in longer list (column A, it is in .csv format and needs to be in it so coordinates and names and ID, all sorted with commas) and I have another list (column C) which is shorter list of certain IDs. I googled and tried and got some results for the basic structure but the fuction seems to fail. It doesn't matter how I get that third list done, but there is only one criteria: since the list in column A is really long and those entries need to keep the .csv formatting, the function should copy that info what is in the matching cells.

Let me try to put it simple: .csv cells from column A that have matching ID from column C should be copied to column B (or N).

the function I'm working with right now is

=IF(ISERROR(FIND($C:$C; A1))=TRUE;"0";A1)

what I'm afraid of is that the find fuction can't use a list (column) as substring. Am I right or is there some other mistake, if not, please a bit of help would be appriciated.

ajn90

unfortunately its not working. It gives error about missing the search value A1. The table of entries is the same and I tried "*"&A1&"*" instead of just A1, same results.

I think there is something going on with the long .csv info on column A, the data is in form "coordinates, coordinates, ID, name" and I need to compare it to just the column C which has only the IDs.

Maybe if you upload your sample workbook, more clear to us how to solve the problem..

Click "Go Advance" button and then find "Paperclip" button to attach your file

Thanks

Okey I put a simple example in this - I needed to re-write everything since the data in original is private. Also at this computer I don't have excel 2010 at my use, I hope libreoffice sample saved in excel format will do...

the goal was to find and print entries from column A that have the ID from column C to column B.

Thanks for replies so far!

nathansav, that fuction is not working as intented I think: it prints 0 or 1 and as I tried it, it gave "1" for almost every entry and all of column C entries are in the column A values. As far as I know your function compares C values to all A which is the opposite as intented?

Thanks
ajn

Something like this maybe? PLease check the file

Cheers
Azumi

Thanks azumi for helping with this. However, why is value "-" printed to all in column B? There are matches in my example sheet, ie C3 ID(100117) is a part of A20(23.3,27,4,100117,set18). What I was thinking was to copy the whole cell from column A if it has the ID from column C.

cheers
ajn90

Oh yes sorry my bad. Here is new examplerefined. Btw I couldn't get your formula to work icestationzbra.

I used ctrl shift enter.