Results 1 to 8 of 8

Lookup Query

Threaded View

  1. #1
    Registered User
    Join Date
    06-02-2011
    Location
    London,England
    MS-Off Ver
    Excel 2007
    Posts
    13

    Cool Lookup Query

    I was wondering if someone can help me. I am looking for a formula that can pick up the last with content of X01, X02 etc.. within a Row. As i need the formula to pick up only cells that have "X"

    I am currently using =IF(A17="","",(LOOKUP("xx",L17:AE17))) to pick up the any content but i need another one that pick up specfic cell that Contain X01, X02 etc,

    See attachment as reference

    Thanks
    Attached Files Attached Files

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