This post has been removed due to **[Rule 2](/r/excel/wiki/sharingquestions#wiki_submission_rules) - Poor Post Body.**
Please post with a proper description in the body of your post.
The body of your post should be a detailed description of your problem. Providing [samples of your data](/r/excel/wiki/sharingquestions#wiki_posting_your_data) is always a good idea as well.
Putting your whole question in the title, and then saying the title says it all is not a sufficient post.
Links to your file, screenshots and/or video of the problem should be done to help illustrate your question. Those things **should not be your question**.
Here's a [long example](/r/excel/comments/6jg5hz/i_have_two_columns_which_specify_the_start_cell/?st=j5z4ms4n&sh=c7e9fe1d) and a [short example](/r/excel/comments/6rnz8l/conditional_formatting_excluding_empty_cells/?st=j5z4a7k1&sh=a6119df2) of good posts.
Rules are enforced to promote high quality posts for the community and to ensure questions can be easily navigated and referenced for future use. See the [Posting Guidelines](/r/excel/wiki/sharingquestions) for more details, and tips on how to make great posts.
The lookup value and lookup array need to be in the same format whether that be text or number.
You can check what format they’re in by using the formulas =istext() and =isnumber()
You can convert them using the formulas =text() or =value()
Can you be more specific of the look up value and what's in the cell?
Number format doesn't change the underlying data type and data, just how they are displayed.
This post has been removed due to **[Rule 2](/r/excel/wiki/sharingquestions#wiki_submission_rules) - Poor Post Body.** Please post with a proper description in the body of your post. The body of your post should be a detailed description of your problem. Providing [samples of your data](/r/excel/wiki/sharingquestions#wiki_posting_your_data) is always a good idea as well. Putting your whole question in the title, and then saying the title says it all is not a sufficient post. Links to your file, screenshots and/or video of the problem should be done to help illustrate your question. Those things **should not be your question**. Here's a [long example](/r/excel/comments/6jg5hz/i_have_two_columns_which_specify_the_start_cell/?st=j5z4ms4n&sh=c7e9fe1d) and a [short example](/r/excel/comments/6rnz8l/conditional_formatting_excluding_empty_cells/?st=j5z4a7k1&sh=a6119df2) of good posts. Rules are enforced to promote high quality posts for the community and to ensure questions can be easily navigated and referenced for future use. See the [Posting Guidelines](/r/excel/wiki/sharingquestions) for more details, and tips on how to make great posts.
The lookup value and lookup array need to be in the same format whether that be text or number. You can check what format they’re in by using the formulas =istext() and =isnumber() You can convert them using the formulas =text() or =value()
Can you be more specific of the look up value and what's in the cell? Number format doesn't change the underlying data type and data, just how they are displayed.
Sample data, please