Solved

Formula to find equal amount

Posted on 2014-03-13
4
145 Views
Last Modified: 2014-03-17
I need a formula where

If Sheet1 I1 = "Yes" and if Sheet1:B1 value is found on Sheet2 in Column B then insert Sheet1 B1 into Sheet1 J1 else insert Sheet1 A1 into Sheet1 J1

Thanks in advance
0
Comment
Question by:leezac
  • 2
  • 2
4 Comments
 
LVL 39

Expert Comment

by:nutsch
ID: 39927943
in Sheet1 J1, use the following formula

=IF(AND(I1="Yes",NOT(ISNA(MATCH(B1,B:B,0)))),B1,A1)
0
 

Author Comment

by:leezac
ID: 39927962
I tried to edit before someone posted.  

If I1 = "Yes" and  Sheet1 B1 = Sheet2 A (any row or is a match)
then insert Sheet 2's value from column B in J1 on Sheet1

else if  I1 = "No" then insert Sheet1 A1 value into J1


Sorry - I tried to edit. Hopefully it will be easy to change.
0
 
LVL 39

Accepted Solution

by:
nutsch earned 500 total points
ID: 39928013
like this?

=IF(I1="Yes",IFERROR(VLOOKUP(B1,Sheet2!A:B,2,0),A1),A1)
0
 

Author Comment

by:leezac
ID: 39928309
Yes, I believe will work..  Will test tomorrow -- Thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Control calculations in Excel using VBA 4 22
Hiding column macro 10 28
What is format f12.8 for a CSV file 6 41
Vlookup formula error 15 11
Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

867 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

17 Experts available now in Live!

Get 1:1 Help Now