INDEX/MATCH vs. VLOOKUP between two sheets
I have two sheets with identical columns - Market Name and Organization Name. I'm using dropdowns in these columns since I have external folks reporting into a form and I want the names to match across my entire workspace.
I want to copy Organization Name from one sheet to the other, and match on the Market Name. I feel like this should be simple, but I've tried using VLOOKUP and INDEX/MATCH and I am having trouble getting either to work. I use VLOOKUP in excel frequently but I think I'm missing something here in Smartsheet. Based on other similar threads, it also seems like INDEX/MATCH might be the better way to go. Screen shots below for reference.
Sheet 1 (where I want to put the formula in the Organization Name column). This is currently filled in with made up sample information, but eventually will have lots of rows of data from all of the organizations I work with.
Sheet 2 (I want to pull the Organization name from this sheet, matched on Market Name)
Help Article Resources
Check out the Formula Handbook template!