Multiple Lookup Values

seguin85

Active Member
Joined
Mar 17, 2015
Messages
262
Office Version
365
Platform
Windows
Hi,

I have two tables similar to the following:
1.
ABCDEFGH
Codeop1op2op3op4op5op6op7
1ABC123XYnoneZZWRnonenoneLUG
2XYZ789nonenoneZZnoneLUGXYnone

<tbody>
</tbody>
In this table each of the options has a drop down from a defined list.

2.
ABCDEFGHI
1Step#XYXXWRLUGFSJZZPSNWEI
2Step111100011
3Step201001011

<tbody>
</tbody>

What I want is a formula that will return 1 if any of the options in the #1 table have a 1 in the #2 table or return 0 if none of the options are met.
Any suggestions on where to get started?
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

DSCfromCFA

Board Regular
Joined
Feb 27, 2018
Messages
141
Office Version
365
Platform
Windows
G'day seguin85,

A little more information may help get an answer.
Where do you want the "1" to appear if the conditions are met?
Do you only want one "1" or is it a "1" for every time the conditions are met for each option?

Cheers

shane
 

seguin85

Active Member
Joined
Mar 17, 2015
Messages
262
Office Version
365
Platform
Windows
It will be on a second sheet, but in column I on table 1 will do and I can reference that from that page. Also, I just want 1 if any conditions are met and 0 if none are met. Thanks!
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,646
Office Version
365
Platform
Windows
Can you state what the results for your sample data should be and set out the steps that you would do manually to get those results?
 

Watch MrExcel Video

Forum statistics

Threads
1,099,122
Messages
5,466,819
Members
406,500
Latest member
Tknotmaxx

This Week's Hot Topics

Top