Hello,
I have two columns of data - Column A has a list of stocks and Column B has names of stocks from that list that are private. I'd like to write an IF formula based on a Match statement that will show the word "Private" if a stock from the first list appears in the second list, and "Public" if not.
Any suggestions on how to do this?
Thanks for the help
use IF (ISERROR( [lookup] ),"Public","Private"), where [lookup] checks list 2 for the stock name. If you need help with this, upload a dummy file with a sample or two and someone will insert the appropriate formulas.
Attached is an example of what I'm looking for
In row 2 and copied down:
Please note that they have to be an EXACT match.
Please Login or Register to view this content.
financegrl,
In cell C2 and copied down:
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Back at you with an answer.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Brilliant! Worked like a charm!
In C2:
dragged down. Just like bentleybob said, reallyPlease Login or Register to view this content.
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
Hi Alan,Originally Posted by alansidman
Have you the right thread? Your attachment looks completely different from the OPs - I'd hate to see your good work go to waste.
All the best,
Brendan;
Thanks. I posted the wrong spreadsheet. My solution was the same as BentleyBob. Glad the OP got it right and others had jumped in. Thanks for pointing out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks