Join us now. It is free, and it takes less than 1 minute to register.
Register now
Subscribe to our daily newsletter. It is free, and it comes with many benefits.


+ Reply to Thread
Results 1 to 5 of 5

Thread: Looking for an Excel Wiz

  1. #1
    Grandmaster
    Join Date
    Mar 2010
    Location
    Pretoria
    Posts
    2,752
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Looking for an Excel Wiz

    Looking for someone that can help me extract some data in Excel.

    Attached is a sample sheet with some dummy data. (Renamed from .xlsx to .txt)

    I need to have sheet one find a value in sheet 2 (Unit) and then populate the relevant field (Environment) from sheet two to the list in sheet one.

    Re-sorting the sheets is not an option, it will need to be a lookup of sorts.

    It's probably really easy, I'm just a muppet.

    sample_data.txt

  2. #2
    Super Grandmaster Cray's Avatar
    Join Date
    Oct 2010
    Location
    Durban
    Posts
    15,521
    Mentioned
    9 Post(s)
    Tagged
    0 Thread(s)

    Default

    Vlookup

    =VLOOKUP(A2,Sheet2!A:C,3,0)

    This is for Cell B2, but you can drag the formula down for successive cells...

  3. #3
    Master
    Join Date
    Oct 2012
    Posts
    681
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =VLOOKUP(A2;Sheet2!A1:C6;3)
    Replace ";" with ",", if necessary.
    Last edited by Nemus; 17-04-2018 at 01:16 PM.

  4. #4
    Grandmaster
    Join Date
    Mar 2010
    Location
    Pretoria
    Posts
    2,752
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    See, I knew the smart people could do it in like 2 seconds Thanks.

  5. #5
    Super Grandmaster maumau's Avatar
    Join Date
    Aug 2009
    Location
    fairland
    Posts
    10,521
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Agree, there are smart people here and they don't mind sharing their knowledge. Kudos to them.
    Honi Soit Qui Mal Y Pense

+ Reply to Thread

Similar Threads

  1. Excel help
    By Akasha in forum Off Topic
    Replies: 24
    Last Post: 21-07-2015, 09:35 AM
  2. Replies: 19
    Last Post: 01-02-2014, 10:46 AM
  3. Need Excel Help
    By Dr Who in forum Software
    Replies: 7
    Last Post: 17-09-2013, 02:09 PM
  4. EXCEL HELP PLEASE
    By ButterflyXXX in forum Off Topic
    Replies: 50
    Last Post: 25-01-2013, 12:44 PM
  5. Need some help with Excel please
    By Decotey in forum PC Hardware and Gadgets
    Replies: 5
    Last Post: 05-01-2009, 04:22 PM

Bookmarks

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
  •