I have two sheets in Excel. The first sheet contains a table of exported time sheet data.
On the time sheet data sheet I have a column with the time type and another column with a numeric value representing the hourly rate. There will be duplicate values in the first column. The numeric column will have the same value for each time type, or it may have a 0. An example is below:
[TABLE="width: 500"]
Time Entry Type
[/td]Rate
[/td]Standard Time
[/td]100
[/td]Standard Time
[/td]100
[/td]Premium Time
[/td]150
[/td]Standard Time
[/td]100
[/td]Premium Time
[/td]150
[/td]Standard Time
[/td]0
[/td]Standard Time
[/td]0
[/td]Premium Time
[/td]0
[/td]
[/TABLE]
On the second sheet there is a table with the unique values found in the Time Type column on the first sheet. There are no duplicates.
[TABLE="width: 500"]
Time Entry Type
[/td]Rate
[/td]Standard Time
[/td]Premium Time
[/td]
[/TABLE]
I would like to create a formula, or a macro, that looks for the Time Entry Type from the second sheet, find it in the first sheet, and return the non-zero value in the rate column. In the above example this would mean looking for Standard Time and returning the rate of 100 in the Rate column on sheet two.
I am completely stuck. I can't even offer something to get started. Any help you can offer would be greatly appreciated!