VLOOKUP Nesting Formulas

  • Thread starter Thread starter ajpowers
  • Start date Start date
A

ajpowers

I've been trying to write a vlookup formula that has to see tw
different numbers before it will say TRUE or FALSE.

I write the following for it to look in one column:

=vlookup(a1,d50:f100,2,0)

How do I write it if I have information in cell a1 AND b1? Both hav
to be there before I want it to say TRUE.

Any help
 
<"Both have to be there before I want it to say TRUE.">

Both have to be *where*?
Do the values in A1 and B1 have to be *combined in* column D ?
OR
Do the values in A1 and B1 have to be column D *and* ColumnE ?

Could we have more clarification?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


I've been trying to write a vlookup formula that has to see two
different numbers before it will say TRUE or FALSE.

I write the following for it to look in one column:

=vlookup(a1,d50:f100,2,0)

How do I write it if I have information in cell a1 AND b1? Both have
to be there before I want it to say TRUE.

Any help?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with VLOOKUP 4
Excel IF statement with vlookup 2
Excel Vlookup Help 0
tab name 7
=IF(ISERROR(VLOOKUP(A3,contacts!B:I,5,FALSE)), " ", VLOOKUP(A3,con 4
If statement help 7
Need help in Combining If formula with Vlookup 2
creating nested formulas from drop down box 5

Back
Top