Solved

Excel Question

Posted on 2016-09-13
2
23 Views
Last Modified: 2016-10-02
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
Comment
Question by:Melissa K
  • 2
2 Comments
 
LVL 28

Accepted Solution

by:
Subodh Tiwari (Neeraj) earned 500 total points (awarded by participants)
Comment Utility
On Sheet1
In B3
=IF(B2=Sheet2!C2,Sheet2!C3,"")

Open in new window

1
 
LVL 28

Expert Comment

by:Subodh Tiwari (Neeraj)
Comment Utility
The chosen answer resolved the question.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now