Solved

# Excel problem

Posted on 2016-09-13
28 Views
I need the formula for Excel that if two cells on sheet one are equal to two cell on sheet two, then insert a sheet two value into a cell on sheet one.

Example: If B2 (sheet1) and B3(sheet1) are equal to C2(Sheet2)  and C3(sheet2) then insert C4(sheet 2) into B4(sheet1)
0
Question by:Melissa K
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 31

Accepted Solution

Subodh Tiwari (Neeraj) earned 500 total points (awarded by participants)
ID: 41796644
On Sheet1
In B4
``````=IF(AND(B2=Sheet2!C2,B3=Sheet2!C3),Sheet2!C4,"")
``````
0

LVL 31

Expert Comment

ID: 41825225
The chosen answer resolved the question.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
###### Suggested Courses
Course of the Month6 days, 6 hours left to enroll