My formula works fine with no errors, but no value appears. What is the issue?

I am using another sheet for the lookup_table. The other sheets basically has the currencies and the rates of each currency. What I want to do in the sheet where the function is; basically once a row is added and the currency has been selected, I want it to generate the value of the currency from the other sheet. Therefore, once this formula works I want it to multiply it by the value of the PI. (Table below).

=IF(ISERROR(VLOOKUP([Currency (PI)]1, {currency rates Range 3}, {currency rates Range 4}, false)) = true, "", VLOOKUP([Currency (PI)]1, {currency rates Range 3}, {currency rates Range 4}, false))

This is the other sheet that I'm referencing from to get the rates.

As you can see from the first table.. it is linking fine without any errors but no value appears.


Thank you,

Fatema

Best Answer

Answers

  • Thanks a lot Paul. It worked!

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help! 👍️

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!