• Status: Solved
• Priority: Medium
• Security: Public
• Views: 77

# How to extract and populate data based on 2 matching cells

Good Afternoon Everyone,

I am trying extract data based on matching 2 cells. Can anyone help me with the formula. Thank you

For Ex: If data in C1 = B3 then

Populate
b4 c4
b5 c5
b6 c6
...
0
Dokat
1 Solution

Commented:
how you want these data being populated? can you provide a sample for demonstration?
0

1. What is being populated in the cells B4,C4?
2. What kind of data is in the cells C1=B3?
3. What are the criteria for matching?
4. Are there more than just those 2 cells that are being compare?

If you cold attach an example workbook that would help a lot with figuring out how to help you with this problem.

The simplest formula that could work based on what you have in your question you could fill each cell that needs to be filled with this formula:
``````=IF(C1=B3,"Fill this cell with Data, They match!","There is no match")
``````

Adding that into each cell (B4,C4,B5,C5,B6,C6) Will put the value "Fill this cell with Data, They match!" when they do match and with "There is no match" when they do not.
0

Author Commented:
Thank you for your response. I found a solution for the problem.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.