Results 1 to 3 of 3

Lookup Error with Double Digits

Threaded View

  1. #1
    Registered User
    Join Date
    06-28-2007
    MS-Off Ver
    MS365 (Mac) Version 16.68 (22121100)
    Posts
    41

    Lookup Error with Double Digits

    Please review the attached spreadsheet. I am using a simple LOOKUP formula in R1 - U15, that looks for team members on teams in Column P. Note that the teams that start with 1 (i.e. 1, 10, 11, 12, etc.) all reference Team 1. How can I get them to reference correctly?

    Thank you for your help!
    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