Col I will remain static.
If any cell in col E matches any cell in col I I want it to return "Yes" or "No" if it does not.
Test sheet attached.
Also, if I copy and paste the info into cell E from a csv file will the formula still work?
Thanks
Col I will remain static.
If any cell in col E matches any cell in col I I want it to return "Yes" or "No" if it does not.
Test sheet attached.
Also, if I copy and paste the info into cell E from a csv file will the formula still work?
Thanks
oops...COL F is the destination for the yes or no.
Try this formulas but change the format of col F to number format.
=IF(ISERROR(MATCH(E1,$I$1:$I$26,0)),"NO","YES")
If this post helps, Please don't 4get to click the star icon located at the bottom left of my Post.
Thanks, but that does not appear to be working for me.
Check attache file.
match-iserror.xlsx
Hi
AZIZ formula and also this formula .
=IF(COUNTIF(I:I,E1)>0,"yes","no")
..Work, but you have to find a way to change your format to the columns..
In E1 there is the wors "BAK Bega". Also in I25. Try to do this. =i25=e1 Will gives you FALSE!
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
The data I copy and post into Col E is from a csv file, the csv file is generated from a data base.
The data in Col I is hand typed in.
If I copy say E1 and paste it into Col I the formula works.
Some type of format problem?
got it....your data has trailing spaces so use Trim(E1) and copy down to remove all the extra spaces and then copy these values and by using paste special command only paste values. it will work...
This is a good idea BUT even in this case it will not work for all, because in column I(manually typed),in many occasions there are extra spaces...
See the example
got it .....
Use this formula so you don't need to remove extra spaces manually ....
Don't forget to press Ctrl + Shift + Enter to enter the below formuls.... these {} ll come automatically
{=IF(ISERROR(MATCH(TRIM(D13);TRIM($I$1:$I$26);0));"NO";"YES")}
here is the file and hope it will work
match-error-trim.xlsx
That is looking the goods people, I will just check it with some more real data and see how it goes.
Back shortly.
Brilliant stuff!
Thank you so much for your time and effort people, much appreciated.
Your imported data in Column E is fixed length (30 characters)
In F1
Formula:Please Login or Register to view this content.
Drag/Fill down.
Am I missing something?
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
You are welcome by me
Thanks for the feed back and also for reb*
I tink, aziz, too!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks