VLOOKUP not returning the correct value in cell

**RyanEAS** · 03-07-2012, 01:33 PM

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?

**Cutter** · 03-07-2012, 01:45 PM

Try this:
=VLOOKUP(F1,Facility!B2:E306,2,0)

**RyanEAS** · 03-07-2012, 01:50 PM

That fixed it... thanks!!!

**Cutter** · 03-07-2012, 01:56 PM

You're welcome, and thanks for the 'star tap'. Don't forget to mark your thread as SOLVED.

**RyanEAS** · 03-07-2012, 02:03 PM

Okay... another newb/stupid question.... how do I mark the thread as Solved??? Cant find it on here.

**haru** · 03-07-2012, 02:05 PM

To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more hours have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.