VLOOKUP Nesting Formulas

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
 
R

RagDyer

<"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?
 
Top