Results 1 to 6 of 6

VLOOKUP not returning the correct value in cell

Threaded View

  1. #1
    Registered User
    Join Date
    03-06-2012
    Location
    Evansville, IN
    MS-Off Ver
    Excel 2003
    Posts
    9

    VLOOKUP not returning the correct value in cell

    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?
    Attached Files Attached Files
    Last edited by RyanEAS; 03-07-2012 at 02:06 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1