Results 1 to 5 of 5

Vlookup formula responds selectively for some and not all values

Threaded View

  1. #1
    Registered User
    Join Date
    08-18-2009
    Location
    Coral Springs, Florida
    MS-Off Ver
    Excel 2003
    Posts
    9

    Talking Vlookup formula responds selectively for some and not all values

    Hello,
    =IF(G88="PT",VLOOKUP(B88,Vlookup1!A:R,5),IF(G88="OT",VLOOKUP(B88,Vlookup1!A:R,6),IF(G88="ST",VLOOKUP(B88,Vlookup1!A:R,7),FALSE)))

    Two tabs in an excel spreadsheet. One with this formula and another one named Vlookup1 with the info (three columns indicating diagnosis codes for PT (Physical Therapy), OT (Occupational Therapy) and ST (Speech Therapy).

    Out of approximately 350 rows, this formula works perfectly fine with all but three customers’ names. It seems to be only with the last three customers –sorted alphabetically– and can’t figure out how to solve it.
    Have reduced the amount of rows in the info tab / have changed the format of all cells for these 3 customers / have retyped all information under another row and inserted above all the conflict rows but it always brings “0” as the cell value – not even False….

    Help!!
    Last edited by Amarilis Abreu; 08-24-2009 at 03:09 PM.

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