# How do I display something from 2 cells if a conditions matches in another.

Here is what I want to do. If the value of Cell M2 is equal to or greater than 4, I want to display the value of Cell H2 and Cell A2 in Cells  N2 and O2. Just clear it up the title for Column A  is Numbers, Column H is Assigned to and Column M is Days open.
LVL 19
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Microsoft Excel ExpertCommented:
Book1.xlsx

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Microsoft Excel ExpertCommented:
i was not sure if you wanted the H2 and A2 joined together or seperate, so i have created two sheets, one of them for joint and the other one is just to show if single value. see the attached workbook
Commented:
You need to use an IF condition in the formula.

Formula in N2      =IF(M2>=4,H2,"")
Formula in O2      =IF(M2>=4,A2,"")

It's not very clear to me what you want to display IF the value in M2 is less than 4. I've just made it a blank here.