Vlookup if range of cells greater than 0 display blank

Hi guys

I have made a spreadsheet that essentially works out.

The 1 st Column A is the ID
The 2nd Column B is the Contact name
The 3rd Column C is the Amount.


Sheet Name: Main Report

In the 2nd column I have this formulae:

=VLOOKUP(A2,'ContactRate'!A:B,2,0)

This work fine.

|Id |Contact |Amount|
------|---------------------|
6003 |#N/A |0
------|---------------------|
6004 |Email |0
----------------------------|
6008 |#N/A |0
----------------------------|
6009 |#N/A |34.34
----------------------------|
6010 |#N/A |0
----------------------------|
6011 |#N/A |0
----------------------------|


Sheet Name: Contact
|Id |Contact |
------|------------
6001 |Outgoing |
------|------------
6004 |Email |
-------------------
6005|Outgoing |
-------------------
6008 |Outgoing |
-------------------
6014 |Outgoing |
-------------------
6013 | Outgoing |



However, the spreadsheet has about 100 entries all the cells in column B are showing "#N/A" because there are no values for them to work with.


This for some reason doesn't work with VLOOKUP. Not the way I am using it anyway

=IF(C2 >0,"=VLOOKUP(A2,'Contact'!A:B,2,0)

Can anyone shine any light on this and let me know where I am going wrong?

I don't like seeing this and normally will use the "IF" function to say that if column C are greater than 0 then show Blank instead of #N/A in Column B. In Theory ID 6009 Column B should be Blank

output
Sheet Name: Main Report

|Id |Contact |Amount|
------|---------------------|
6003 |#N/A |0
------|---------------------|
6004 |Email |0
----------------------------|
6008 |#N/A |0
----------------------------|
6009 | Blank |34.34
----------------------------|
6010 |#N/A |0
----------------------------|
6011 |#N/A |0
----------------------------|


Many Thanks
AD

if you are returning errors (#N/A) you can put an iferror on the formula, like...
=IFERROR(VLOOKUP(A2,'Contact'!A:B,2,0),"")
your syntax was wrong in the =IF(C2 >0,"=VLOOKUP(A2,'Contact'!A:B,2,0)

Thanks Sam, I have if condition along with the Lookup, If Column C is greater than zero display blank or else N/A ("Not Applicable")

I'm guessing because I cannot really tell what you have and what you want and where the issue is. So as I noted, if this is your formula

=IF(C2 >0,"=VLOOKUP(A2,'Contact'!A:B,2,0)
the syntax in this is wrong, and usually with an IF/THEN statement you have a "what happens if the condition isn't satisfied" statement. IF(this condition exists do this, otherwise do that)

maybe you want this? =IF(C2 >0,"",VLOOKUP(A2,'Contact'!A:B,2,0)
or this... =IF(C2 >0,VLOOKUP(A2,'Contact'!A:B,2,0),"")

Good, glad that worked for you, AND thank you for the rep!