LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 287
Default ISNA match function help

Ok, i need some help.

I have two columns of data. For one of the columns, i need to find out if
its contained somewhere, anywhere in the other column. So how was going to
do it was useing an ISNA, Match function and create a new column called
Missing?, and then drag the code down, if its not contained then it will
output True, if it is there, then it will output False. This usually works
great. The only problem im having is that my column contents are kinda
wacky. Here are some examples

M4758375
12-67-8
056-76-23
08-22-456

So both columns have data like this. And for some reason, my ISNA code isnt
working.

Any ideas?

Thanks,

-Adam
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If isna match vlookup formula maijiuli Excel Worksheet Functions 6 November 20th 07 10:09 PM
VLOOKUP and LEN/ISNA to match names? LTUser54 Excel Worksheet Functions 6 May 22nd 06 09:08 PM
ISNA(MATCH...) and IF functions - can they be combined? Robyn from Melbourne, Australia Excel Worksheet Functions 1 November 11th 05 05:18 AM
IsNA(match Sanz Excel Worksheet Functions 1 May 23rd 05 09:11 PM
IsNA(match Duke Carey Excel Worksheet Functions 0 May 23rd 05 06:10 PM


All times are GMT +1. The time now is 08:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"