AI Assistant
Help Center AI Assistant is now available
Got questions about Lark? Use our AI chat to find the answers.
00:00
Click and hold to drag
Got It
Try Now

EXACT function for Sheets

1 min read
I. Intro
The EXACT function is commonly used to check whether two text strings are identical. If they are, it will return TRUE, otherwise, it will return FALSE.
II. About the function
  • Formula: =EXACT(string1,string2)
  • Arguments:
  • String1 (required): The first text string to be compared.
  • String2 (required): The second text string to be compared.
  • Example:
  • =EXACT ("hello","hello") returns TRUE.
III. Steps
Use the function
  1. Select a cell and click Formulas on the toolbar, then select Text > EXACT. You can also directly enter =EXACT in a cell.
  1. Enter the parameters in the cell. For example: =EXACT(E7,F7) or =EXACT(E7,G7).
  1. Press Enter to display the results. TRUE indicates they're identical and FALSE indicates they're not.
250px|700px|reset
Delete the function
Select the cell with the EXACT and press Delete.
IV. Use case
HR: Verify data accuracy
It's important for HR to check if the information they have is accurate or up-to-date. With the EXACT function, it's easy to compare two sets of data to verify if they are the same.
  • Formula used below: =EXACT(B2,C2)
  • About the parameters: The example below compares two sets of phone numbers to check if they've been updated. Column B is compared to column C, and if TRUE is returned, the two phone numbers are identical and FALSE indicates they're not.
250px|700px|reset
V. FAQs
When using the EXACT function to check if two strings are identical, is case sensitivity taken into account?
Yes, the EXACT function is case sensitive, which means 'Hello' and 'hello' are considered different strings.
Written by: Lark Help Center
Updated on 2024-11-25
How satisfied are you with this content?
Thank you for your feedback!
Need more help? Please contact Support.
0
rangeDom
rangeDom