Vlookup 'And' statement

Hi all,

I am looking for help with a vlookup formula.

I am trying to return a value based on two different cell values, and have been told you can do some kind of 'AND' statement.

Does anybody know about this?

I.e. In cell D2 I want to return the value using the criteria in Cell B2 and Cell C2. Is this possible

Hi

Please post what is in the cells and what you'd like to be in the cells -
and the methodology used!! What do you mean by 'criteria in cell B2 and cell
C2'?
Maybe something like:
=IF(AND(B2>6,C2<4),"Y","N")

Andy.

"moglione1" <[email protected]> wrote
in message news:[email protected]...
>
> Hi all,
>
> I am looking for help with a vlookup formula.
>
> I am trying to return a value based on two different cell values, and
> have been told you can do some kind of 'AND' statement.
>
> Does anybody know about this?
>
> I.e. In cell D2 I want to return the value using the criteria in Cell
> B2 and Cell C2. Is this possible
>
>
> --
> moglione1
> ------------------------------------------------------------------------
> moglione1's Profile:
> http://www.excelforum.com/member.php...o&userid=26414
> View this thread: http://www.excelforum.com/showthread...hreadid=520610
>