- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Formula that returns TRUE if values in column A are also in column B
Good Afternoon,
After hours of research, I don't understand how to solve the following problem:
I have a table with several columns, including column A which contains a character string and column B which also contains a character string.
I would like a formula that allows me to have an additional column in which there would be "TRUE" if the values entered in column A are also present in column B.
The values in column A can be present several times in column B.
Ex : if my value A2 is present in line 50 of the column B, then we return TRUE otherwise we return FALSE.
Does anyone know how to do this?
Have a good day,
Charlotte
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Charlott_9,
If I correctly understand your explanation, you need a calculated column like this:
Best Regards,
Alexander
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Charlott_9,
If I correctly understand your explanation, you need a calculated column like this:
Best Regards,
Alexander
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
It answers my request perfectly! Thanks a lot!
Have a good day,

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
04-29-2024 10:22 AM | |||
07-03-2024 06:34 AM | |||
07-27-2024 01:39 PM | |||
12-28-2023 06:46 AM | |||
03-22-2024 06:48 AM |
User | Count |
---|---|
14 | |
14 | |
11 | |
11 | |
8 |