jwalkerday
New Member
- Joined
- May 1, 2018
- Messages
- 18
Sheet1
[TABLE="width: 191"]
<tbody>[TR]
[TD][/TD]
[TD]2019
[/TD]
[TD]2020
[/TD]
[/TR]
[TR]
[TD]1234
[/TD]
[TD]54
[/TD]
[TD]66
[/TD]
[/TR]
[TR]
[TD]5678
[/TD]
[TD]14
[/TD]
[TD]44
[/TD]
[/TR]
</tbody>[/TABLE]
Sheet2
[TABLE="width: 287"]
<tbody>[TR]
[TD][/TD]
[TD]2019
[/TD]
[TD]2019
[/TD]
[TD]2019
[/TD]
[/TR]
[TR]
[TD]Result Flag
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Result
[/TD]
[/TR]
[TR]
[TD]1234
[/TD]
[TD]54
[/TD]
[TD]51
[/TD]
[TD]77
[/TD]
[/TR]
[TR]
[TD]5678
[/TD]
[TD]14
[/TD]
[TD]28
[/TD]
[TD]101
[/TD]
[/TR]
</tbody>[/TABLE]
=HLOOKUP(B$1,Sheet2!$A$1:$Y$4,MATCH($A2,Sheet2!$A$1:$A$4,FALSE),FALSE)
Hi,
Above you can see a shortened version of my 2 sheets. The hlookup you can see highlighted in blue returns the first value that matches the year And the reference code (1234).
However I want the value underneath the result flag(77). I've looked into a few different functions (IF, MATCH,INDEX) but been unable to successfully Return the result value.
So, I need to check for the year; then check if the result flag is present and then return the value.
Can anyone help?
[TABLE="width: 191"]
<tbody>[TR]
[TD][/TD]
[TD]2019
[/TD]
[TD]2020
[/TD]
[/TR]
[TR]
[TD]1234
[/TD]
[TD]54
[/TD]
[TD]66
[/TD]
[/TR]
[TR]
[TD]5678
[/TD]
[TD]14
[/TD]
[TD]44
[/TD]
[/TR]
</tbody>[/TABLE]
Sheet2
[TABLE="width: 287"]
<tbody>[TR]
[TD][/TD]
[TD]2019
[/TD]
[TD]2019
[/TD]
[TD]2019
[/TD]
[/TR]
[TR]
[TD]Result Flag
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Result
[/TD]
[/TR]
[TR]
[TD]1234
[/TD]
[TD]54
[/TD]
[TD]51
[/TD]
[TD]77
[/TD]
[/TR]
[TR]
[TD]5678
[/TD]
[TD]14
[/TD]
[TD]28
[/TD]
[TD]101
[/TD]
[/TR]
</tbody>[/TABLE]
=HLOOKUP(B$1,Sheet2!$A$1:$Y$4,MATCH($A2,Sheet2!$A$1:$A$4,FALSE),FALSE)
Hi,
Above you can see a shortened version of my 2 sheets. The hlookup you can see highlighted in blue returns the first value that matches the year And the reference code (1234).
However I want the value underneath the result flag(77). I've looked into a few different functions (IF, MATCH,INDEX) but been unable to successfully Return the result value.
So, I need to check for the year; then check if the result flag is present and then return the value.
Can anyone help?