+ Reply to Thread
Results 1 to 3 of 3

lookup for a specific string-help please

  1. #1
    Registered User
    Join Date
    03-25-2005
    Posts
    27

    lookup for a specific string-help please

    Hi,

    Am a new member to this forum. I want a help from you all XL grurus. It may be very easy for you. But, for me it is a brow crinkling one. I want to use lookup function to sor a specific string in a colum so as to figure out the correspoding value in the other column.

    Can you please see the attached zip file and help me out in this problem. In that XL file sheet Abstract you can find the fucntion what I have pu, but! I could not get the result other than #NA!!!

    reagards

    Vinu
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-18-2004
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    1,474
    Try...

    =VLOOKUP("Total Excavation",DETAILS!B4:H800,7,0)

    or

    =VLOOKUP("Total Excavation",DETAILS!B:H,7,0)

    Hope this helps!

  3. #3
    Registered User
    Join Date
    03-25-2005
    Posts
    27
    Hi Domenic ,

    Thanks a lot, the second one really works. It really saved my time and tiresome work too.

    Expect your valued guidance in future too.

    wishin you to the best of the bests

    regards
    Vinu

+ Reply to Thread

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