Hello everyone,
Hope this will something simple for an Excel expert as I don't even really know where to start (Vlookup, Index Match...?
I have a large data set that I call 'Conditional Raw data lookup' for reference in my sample on the bottom.
Eg.
Condition1 12345 is valid if Condition 2 is either '111' ; '222' ; '333' ; '444 or '555'
Also
Condition1 23456 is valid if Condition 2 is either '666' ; '777' ; '888' ; '555' or '999'
On the top of my table I want an output (in Column C2 - C5) that if Condition1 12345 and Condition2 matches the raw data.
In Row2 it is 12345 and Condition 2 '111' which is maintained in the Raw data so it should say 'Yes'
In Row3 it is again 12345 but Condition 2 is '666' and this is not maintained in the Raw data so it should say 'NO'
Its a bit difficult to explain. So hopefully my sample will show it better. This is just very limited sample date. It will be much more data at the end.
<tbody>
</tbody>
Hope someone can help.
Thanks
Hope this will something simple for an Excel expert as I don't even really know where to start (Vlookup, Index Match...?
I have a large data set that I call 'Conditional Raw data lookup' for reference in my sample on the bottom.
Eg.
Condition1 12345 is valid if Condition 2 is either '111' ; '222' ; '333' ; '444 or '555'
Also
Condition1 23456 is valid if Condition 2 is either '666' ; '777' ; '888' ; '555' or '999'
On the top of my table I want an output (in Column C2 - C5) that if Condition1 12345 and Condition2 matches the raw data.
In Row2 it is 12345 and Condition 2 '111' which is maintained in the Raw data so it should say 'Yes'
In Row3 it is again 12345 but Condition 2 is '666' and this is not maintained in the Raw data so it should say 'NO'
Its a bit difficult to explain. So hopefully my sample will show it better. This is just very limited sample date. It will be much more data at the end.
Condition 1 | Condition 2 | Condition fulfilled? |
12345 | 111 | Yes |
12345 | 666 | No |
23456 | 666 | Yes |
23456 | 444 | No |
Conditional Raw data lookup | ||
Condition 1 | Condition 2 | |
12345 | 111 | |
12345 | 222 | |
12345 | 333 | |
12345 | 444 | |
12345 | 555 | |
23456 | 666 | |
23456 | 777 | |
23456 | 888 | |
23456 | 555 | |
23456 | 999 |
<tbody>
</tbody>
Hope someone can help.
Thanks