Results 1 to 3 of 3

Thread: lookup a single value and return related texts in multiple columns horizontally

  1. #1

    lookup a single value and return related texts in multiple columns horizontally



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello Everyone


    I'm having a hard time with this one


    I want t lookup ATM no. in sheet 2 and return related BRANCH, ZONE ID, and CITY details, horizontally in sheet 1.

    Any help would be appreciated...



    Thanks
    Attached Files Attached Files

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi Ailene,
    pl use the formula Vlookup.

    Pl find attached file.
    Attached Files Attached Files

  3. #3
    Hi Sambit

    Many thanks, this looks good.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •