VLOOKUP/IF Formula Question -- What's the best way to accomplish this?

Options

Hi all,

I'm struggling with utilizing an if statement with a lookup table in a reference sheet. I've tried a few different combinations and all return an incorrect argument error. To be honest, I'm not sure that utilizing either of these functions is my best route to take.

This is what I want to accomplish:

If the Date corresponds with the Date on the reference sheet then I want to return the number in the next column on the reference sheet for the same row that Date appears in. The purpose of this sheet is to house daily values for numerous other sources to use as a data source for a dashboard.

My reference sheet is set up the same way:

Any input if greatly appreciated!

Thank you,

Kristina

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!