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

    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
    14,646

    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

    Default

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

  4. #4

    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
    9,939

    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
  •