HLookup work around

Eric Z

I'm brand new to Smartsheet and trying to figure out the best (most elegant) solution to get the result illustrated in the screenshot below. Any help/suggestions would be most appreciated. TIA

Paul Newcome

Take a look at this thread:

https://community.smartsheet.com/discussion/72979/need-a-clear-example-of-using-index-and-match-in-lieu-of-hlookup