Check if Combination exists

  • Thread starter Thread starter newguy
  • Start date Start date
N

newguy

I am sure this is easy I have a 2 column table with one containing
names and the other containing a number. Based on a user input I want
to see if that combination exists:

Wayne 2
Wayne 3
Porter 5

So if they enter Wayne and the number 3 then a get a true if they
enter Wayne 5 I get a false.

Thanks
 
I am sure this is easy I have a 2 column table with one containing
names and the other containing a number. Based on a user input I want
to see if that combination exists:

Wayne  2
Wayne  3
Porter   5

So if they enter Wayne and the number 3 then a get a true if they
enter Wayne 5 I get a false.

Thanks
Click to expand...

Elaborate. Do you want this in a formula with/without drop downs, a
macro, ???
 
Elaborate. Do you want this in a formula with/without drop downs, a
macro, ???
Click to expand...

What the user inputs is a combination drop down and then they type in
a number. I would like to use a formula below is what I have to see if
it exists. The way I have it right now is I have added a 3 column to
my table which concatenates the first 2 values of the table since this
will make it uniques. I am using a if(isna(vlookup)) formula to see if
what the user has inputed is a posibility in the table.

=IF(AND(I369>0,ISNA(VLOOKUP(J390,QC,3,FALSE))),1.3,0)

J390 is a concatenation of the 2 values that the user inputs to
compare with the table.
QC is the defined table range

I don't know how clear that is but hopefully it will help

Thanks again
 
What the user inputs is a combination drop down and then they type in
a number. I would like to use a formula below is what I have to see if
it exists. The way I have it right now is I have added a 3 column to
my table which concatenates the first 2 values of the table since this
will make it uniques. I am using a if(isna(vlookup)) formula to see if
what the user has inputed is a posibility in the table.

=IF(AND(I369>0,ISNA(VLOOKUP(J390,QC,3,FALSE))),1.3,0)

J390 is a concatenation of the 2 values that the user inputs to
compare with the table.
QC is the defined table range

I don't know how clear that is but hopefully it will help

Thanks again- Hide quoted text -

- Show quoted text -
Click to expand...

"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."
 
Back
Top