Results 1 to 4 of 4

VLOOKUP and INDEX

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-22-2004
    Location
    Kokomo, Indiana
    Posts
    236

    Question VLOOKUP and INDEX

    My system is using XP Pro with MS Excel 2007. I have spreadsheet I'm trying to use as a status sheet. See attached spreadsheet. There is a format control that has my projects listed. Once a project is selected my expectation is to have all (currently most) cells to auto populate. There is a project called Rehab Kirkuk Museum-CERP and when I select this everything populates exactly as I wanted it to. Next I select another project, like the first and all is fine. But when I select another different project than the Rehab Kirkuk Musem project nothing happens. Selecting a different project each time results in nothing. Only when I return to the Rehab Kirkuk Museum-CERP does everything populate again. In the next selection is fine as well, but after that nothing works correctly. What is wrong with my setup? I suspect my Index and Vlookup functions are somehow having difficulty with my data. How do I fix this? See attached spreadsheet.

    Tony
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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