# GoogleSheet VLookup and test for Error

I have a list of for example 25 cryptos that I invest in. In a separate sheet called "CryptoJayTargets", I have his price estimate for year end for a list of 15 cryptos.

I want to create a formula to lookup his target, but if his target isn't found (i.e. I don't have the crypto symbol on that sheet, I want to set the value to 3x my purchase price from Column R5). [Column P5 is the symbol/abbreviation for the crypto].

The VLookup works fine when there is a match on the symbol/abbreviation. But when no match found it just says "#N/A" in the column.

Here are three things I tried. Seems like I want an "else" on the IFERROR function.

=IF(VLOOKUP($P5,CryptoJayTargets!$A$1:$C$100,3,FALSE)='#N/A',3*$R5,VLOOKUP($P5,CryptoJayTargets!$A$1:$C$100,3,FALSE)) This is wrong because IFERROR requires only two arguments: =IFERROR(VLOOKUP($P5,CryptoJayTargets!$A$1:$C$100,3,FALSE),3*$R5,VLOOKUP($P5,CryptoJayTargets!$A$1:$C$100,3,FALSE))

And also:

=IF(IFERROR(VLOOKUP($P5,CryptoJayTargets!$A$1:$C$100,3,FALSE),'ERROR')='ERROR',3*$R5,VLOOKUP($P5,CryptoJayTargets!$A$1:$C$100,3,FALSE)) and: =IF(IFERROR(VLOOKUP($P10,CryptoJayTargets!$A$1:$C$100,3,FALSE),3*$R10),VLOOKUP($P10,CryptoJayTargets!$A$1:$C$100,3,FALSE))

=IF(ISNUMBER(MATCH($P5,CryptoJayTargets!$A$1:$A$100,0)),VLOOKUP($P5,CryptoJayTargets!$A$1:$C$100,3,FALSE),$M5*3) based on this question on StackOverflow. To break it down, I got this working first: =MATCH($P6,CryptoJayTargets!A1:A100,0)