fingermouse
Board Regular
- Joined
- Dec 13, 2013
- Messages
- 117
Hi,
I have a problem which I cant solve, will do my best to explain. I think I need something called an index match formula? but I cant get it to work.
I have two excel spreadsheet tabs. Tab 1 contains the data I want to extract, tab 2 will contain the formula
The table below is an extract of tab 1. There are multiple rows for each ref no, of which I have approx 40.
<tbody>
</tbody>
Tab 2 is where I want to have my formula.
<tbody>
</tbody>
What I essentially want to do is pull through both the 'HGBI' and 'LF' values from tab 1 where there is a corresponding 'Ref no' AND 'Eligible Heat Output' value in tab 2. Does that make sense? I tried a VLOOKUP but it only pulls out the first value it finds. I have tried reading tutorials on this but find it confusing. If anyone can provide the formula that would be much appreciated. Thanks, Cal.
I have a problem which I cant solve, will do my best to explain. I think I need something called an index match formula? but I cant get it to work.
I have two excel spreadsheet tabs. Tab 1 contains the data I want to extract, tab 2 will contain the formula
The table below is an extract of tab 1. There are multiple rows for each ref no, of which I have approx 40.
Ref no |
<tbody> </tbody><colgroup><col></colgroup> | HGBI | LF | |
NIRHI00004365 | 76,130 | 77,060 | 35.64 | |
NIRHI00004365 | 50,236 | 51,430 | 24.05 | |
NIRHI00004365 | 50,247 | 79,180 | 36.22 |
<tbody>
</tbody>
Tab 2 is where I want to have my formula.
Ref no | EHO | Lookup for HGBI in this column cells | Lookup for LF in this column cells |
NIRHI00004365 | 76,130 | ||
NIRHI00004365 | 50,236 | ||
NIRHI00004365 | 50,247 |
<tbody>
</tbody>
What I essentially want to do is pull through both the 'HGBI' and 'LF' values from tab 1 where there is a corresponding 'Ref no' AND 'Eligible Heat Output' value in tab 2. Does that make sense? I tried a VLOOKUP but it only pulls out the first value it finds. I have tried reading tutorials on this but find it confusing. If anyone can provide the formula that would be much appreciated. Thanks, Cal.