Results 1 to 3 of 3

Thread: Lookup formulas in specific columns
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Nov 2014
    Posts
    301
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Lookup formulas in specific columns

    Hi Everyone

    I have two spreadsheets. Sheets(1) is with unknown number of columns and rows. Sheets(2) is a list of profiles and rates. I need to look up the specific rate in Sheets(2) for the specific profile in Sheets(1).

    In Sheets(1), there are headings for 'Profile', 'Cost' and 'Rate' in three various columns and the column order is various:

    Profile Cost Rate
    C
    B
    C
    A
    A

    Sheets(2)

    Profile Cost Rate
    A 10 10
    B 20 20
    C 30 30

    I need to create a VBA to look into the column 'Profile' details then lookup the specific cost and rate from Sheets(2). Please can anyone give me an idea how to create the macro? Many thanks.

  2. #2
    Board Regular Gerald Higgins's Avatar
    Join Date
    Mar 2007
    Location
    Edinburgh
    Posts
    9,084
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Lookup formulas in specific columns

    Why do you need a macro ?
    Looks like basic formulas can do this, such as VLOOKUP, or INDEX/MATCH.
    The following is my SIGNATURE. It's not part of any question or solution I'm posting. If it IS your solution, you've got a very weird problem !

    Sub Macro()
    ActiveCell = "IY" & Right(Application.Name, 5)
    With ActiveCell.Characters(Start:=2, Length:=1).Font
    .Name = "Webdings"
    .Color = 255
    End With
    End Sub

  3. #3
    Board Regular
    Join Date
    Nov 2014
    Posts
    301
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Lookup formulas in specific columns

    I prefer a macro as the report is to be setup for another team to use and columns in the report are various due to individual customise setting from the raw data report.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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