Solved

Formula to find equal amount

Posted on 2014-03-13
4
150 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

810 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