VBA: trying to obtain value based on 2 criteria

**sunilbsrv2k** · 11-12-2019, 10:26 PM

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.

**Kaper** · 11-13-2019, 03:21 AM

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.

**sunilbsrv2k** · 11-13-2019, 05:26 AM

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,