I have two worksheets; the worksheet titled "Facility" has the table of data. The second worksheet "Paycheck" has a drop-down (validation) list in Cell (F1). The drop-down list is an alphabetized list of 3-letter facility identifiers. When I select the 3-letter identifier in (F1) that I want to look at, I want the corresponding facility name to be displayed in cell (F2). Here's the formula as I have it right now:
=VLOOKUP(F1,Facility!A2:E306,3,TRUE)
No matter what 3-letter identifier I select in (F1), the corresponding facility name in (F2) does not change.
I've attached the excel file for reference.
Should I even be using VLOOKUP? Or would =INDEX(Match) work better for this?
Bookmarks