IF Statement involving columns in two separate sheets, with a return response from a date column

I'm stumped. I have a request to create a formula matching a Vendor ID in the current sheet to the same column in another sheet and if found, return a date from the GL Policy Expiration (second screen shot), which is Range 3 in the first screenshot below. I am getting a #Invalid Operation result. What am I doing incorrectly please? Is there a better formula to use? VLookup didn't work for this one because of column placement.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!