• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 37
  • Last Modified:

Excel problem

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
Melissa K
Asked:
Melissa K
  • 2
1 Solution
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
On Sheet1
In B4
=IF(AND(B2=Sheet2!C2,B3=Sheet2!C3),Sheet2!C4,"")

Open in new window

0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
The chosen answer resolved the question.
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now