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: 167

# Formula to find equal amount

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

0
leezac
• 2
• 2
1 Solution

Commented:
in Sheet1 J1, use the following formula

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

Author Commented:
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

Commented:
like this?

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

Author Commented:
Yes, I believe will work..  Will test tomorrow -- Thanks
0

## Featured Post

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