[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 32
  • 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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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