I need to lookup a column on one sheet and reference a column and value on another sheet.

Robin Hannah
Robin Hannah ✭✭
edited 09/05/20 in Smartsheet Basics

I have a Model# on sheet 1. I need to search for the same Model# on sheet 2 and if found, look at that Model's status and return that value to sheet 1. Caveat: the Model Status on sheet 2 is a drop down list (Complete, Not Complete), so I need whatever value is selected to pull into sheet 1.

I tried a VLOOKUP using the formula below. It returned a NO MATCH even though the value is there. I also tried an INDEX with a VLOOKUP and no luck.

=VLOOKUP([Model #]2, {Check List Range 2}, 2, false)


Best Answers