Results 1 to 9 of 9

VLookup Error

Threaded View

  1. 09-07-2008, 10:56 AM #1
    baffour
    baffour is offline
    Registered User
    Join Date
    09-07-2008
    Location
    Cheltenham England
    Posts
    4

    VLookup Error

    Hi All
    I have created a Vlookup formula but i am getting some errors in the string.
    How can i get the formula to display all the values and data in the string? The error occurs when i select London Regional,Newport, or Peterborough in the relevant cell. See formula below:

    =IF(A35="Belfast","2064203",IF(A35="Durham","2074203",IF(A35="Glasgow","2054203",IF(A35="GRO","Nil",IF(A35="ION","5004209",IF(A35="Liverpool","2024203",IF(A35="London HQ","5004203",IF(A35="London Regional","5004211",)*IF(A35="Newport","2044203",)*IF(A35="Peterborough","2034203"))))))))

    Where am I going wrong with the formula? Hope someone can help

    Andy
    Last edited by baffour; 09-07-2008 at 11:02 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Vlookup error
    By shahcu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2008, 12:23 AM
  2. Vlookup using two columns-needs to match the first two column
    By pduubb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-01-2008, 01:21 PM
  3. Vlookup Ref error
    By jessa_lee in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-29-2008, 03:21 PM
  4. Vlookup Error
    By jat82nd in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-25-2007, 06:25 PM
  5. Vlookup error
    By svincent in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-09-2006, 08:29 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1