VLookUp Issue

[derrikhu]

Hi!

I know this is an Excel forum, but I use Google Sheets. I'm having trouble with a VLookUp function.

Here is the link to my worksheet:

Copy of Growth Bucket to Customize TEMPLATE

HYPOTHETICAL Buffer,Floor,Cap,Liquidity,Portfolio Weight,Hypothetical Index Return,Hypothetical Growth of $100,000,Customized Growth Return Buffer ETF,-9.00%,14.90%,100%,100.00%,5.00%,$173,690,5.00% Power Buffer ETF,-15.00%,9.75%,100%,0.00%,3.00%,$165,419,3.00% Ultra Buffer ETF,-30.00%,6.80%,10...

docs.google.com

Don't worry, it's a copy.

The problem I encounter is anytime column R (hypothetical rate of investment return) is 1.0%. In this case, the VLookUp return is "N/A" and says:

Error Did not find value '0.01' in VLOOKUP evaluation.

How can I correct this?

Thanks!

 

[derrikhu]

The "N/A" appears in highlighted column T, by the way

 

[Michael M]

It seems column "P" is locked, so we can't view it, but I'd say the value derived in the Lookup table from Column "P" may be the issue!

 

[derrikhu]

Oops! I've removed protection

 

[derrikhu]

Found my error, thanks everyone!

 

[Michael M]

Can you share what the problem ended up being ??