VLookUp plus IF function

[MissJoe]

Hi everyone, I'm new here but I've got lots of solutions from this forum before. Now I'm here with a request for your help.

I have two data sheets in excel with info as below.

Sheet 1

Account	Description	Cost Center	Beginning Balance	Debit	Credit	Ending Balance
1000000	Furniture	XX02	2,000	1,500	300	3,200
2000000	Cash	XX04	10,000	12,000	5,600	16,400

<tbody>
</tbody>

Sheet 2

Account	Description	Category 1	Category 2	Category 3	Active?
1000000	Furniture	Balance Sheet	Non-Cur Asset	Property & Equipment
2000000	Cash	Balance Sheet	Current Asset	Cash & Bank Balances

<tbody>
</tbody>

What I would like to do is, if the Value in Sheet 2 Column 1 matches the value in Sheet 1 and if the value in sheet 1 column 7 (ending balance) is greater than 0, I want it to bring out "Yes" in Sheet 1 Column 6 (Active?)

 

[Robert Mika]

Hi everyone, I'm new here but I've got lots of solutions from this forum before. Now I'm here with a request for your help.

I have two data sheets in excel with info as below.

Sheet 1

Account	Description	Cost Center	Beginning Balance	Debit	Credit	Ending Balance
1000000	Furniture	XX02	2,000	1,500	300	3,200
2000000	Cash	XX04	10,000	12,000	5,600	16,400

<TBODY>
</TBODY>

Sheet 2

Account	Description	Category 1	Category 2	Category 3	Active?
1000000	Furniture	Balance Sheet	Non-Cur Asset	Property & Equipment
2000000	Cash	Balance Sheet	Current Asset	Cash & Bank Balances

<TBODY>
</TBODY>

What I would like to do is, if the Value in Sheet 2 Column 1 matches the value in Sheet 1 and if the value in sheet 1 column 7 (ending balance) is greater than 0, I want it to bring out "Yes" in Sheet 1 Column 6 (Active?)

Hello and welcome
Did you mean "Active" in Sheet 2?
If such try:
=IF(VLOOKUP(A2,Sheet1!$A$2:$G$3,7,0)>0,"yes","no")

 

[MissJoe]

Hi Robert,

Thank you for responding.

However, the formula doesn't seem to work. If I may to clarify the question, the data that should result in Sheet 2 Column F2 should look up and match the account numbers in Sheet 2 with Sheet 1 and if they're a match then check if the Ending Balance (Sheet 1 Column G2) then if the balance is greater than 1, then I want it to read "Yes". If not, then "No".

 

[Robert Mika]

Hi Robert,

Thank you for responding.

However, the formula doesn't seem to work. If I may to clarify the question, the data that should result in Sheet 2 Column F2 should look up and match the account numbers in Sheet 2 with Sheet 1 and if they're a match then check if the Ending Balance (Sheet 1 Column G2) then if the balance is greater than 1, then I want it to read "Yes". If not, then "No".

Whcih part does not work?
Are you gettin errors?

GReater than 0(your first post) or 1 your second post?
=IF(VLOOKUP(A2,Sheet1!$A$2:$G$3,7,0)>1,"yes","no")

 

[MissJoe]

I'm sorry. I'll stick with greater than zero.

The formula works! Thanks a loooot.

 

[Robert Mika]

I'm sorry. I'll stick with greater than zero.

The formula works! Thanks a loooot.

You are welcome.