Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 36
  • Last Modified:

Excel Question

I need the formula for Excel that if one cell on sheet one is equal to one cell on sheet two, then insert a sheet two value into a cell on sheet one.

Example: If B2 (sheet1) is equal to C2(Sheet2) then insert C3(sheet 2) into B3(sheet1)
0
Melissa K
Asked:
Melissa K
  • 2
1 Solution
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
On Sheet1
In B3
=IF(B2=Sheet2!C2,Sheet2!C3,"")

Open in new window

1
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
The chosen answer resolved the question.
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

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