+ Reply to Thread
Results 1 to 3 of 3

VBA: trying to obtain value based on 2 criteria

  1. #1
    Registered User
    Join Date
    11-12-2019
    Location
    Bangalore
    MS-Off Ver
    2016
    Posts
    2

    VBA: trying to obtain value based on 2 criteria

    Hi All,

    I'm new to this forum.

    I have a table in excel sheet with several columns; the leftmost column has the names for each row and a subtotal.

    The top 3 rows are headers with different names.

    I have a task to match the top row with a cell in another sheet and then the Month name in second row.

    Based on which I need to obtain the value from the 12th row in the same column.

    This has to continue for all the columns.

    I have written a Macro, but I'm facing initial hurdle of getting the address of the "arng".

    Please help:

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    6,765

    Re: VBA: trying to obtain value based on 2 criteria

    Will you please attach a SMALL sample Excel workbook(s) (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

    1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If trere are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, etc. - please show them all or at least indicate in text) The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).

    3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!

    To attach an Excel file you have to do the following: Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    11-12-2019
    Location
    Bangalore
    MS-Off Ver
    2016
    Posts
    2

    Re: VBA: trying to obtain value based on 2 criteria

    Hi Kaper,

    Thanks for the response.

    Please find attached the Sample Excel file. The last tab is the desired output which will be obtained by multiplying the result by 100000

    Thanks,
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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