Lookup formulas in specific columns

Apple08

Active Member
Joined
Nov 1, 2014
Messages
318
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:

ProfileCost Rate
C
B
C
A
A

<tbody>
</tbody>

Sheets(2)

ProfileCost Rate
A1010
B2020
C3030

<tbody>
</tbody>

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.
 

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
Why do you need a macro ?
Looks like basic formulas can do this, such as VLOOKUP, or INDEX/MATCH.
 

Apple08

Active Member
Joined
Nov 1, 2014
Messages
318
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.
 

Forum statistics

Threads
1,085,210
Messages
5,382,369
Members
401,784
Latest member
Jonnyboisme

Some videos you may like

This Week's Hot Topics

Top