On Aug 5, 10:51*am, newguy <rexbi...@gmail.com> wrote:
> On Aug 5, 10:46*am, Don Guillett Excel MVP <dguille...@austin.rr.com>
> wrote:
>
>
>
>
>
> > On Aug 5, 8:55*am, newguy <rexbi...@gmail.com> wrote:
>
> > > 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
>
> > Elaborate. Do you want this in a formula with/without drop downs, a
> > macro, ???
>
> 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 -
"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."
|
Similar Threads
