Vlookup 'And' statement

[moglione1]

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

 

[Guest]

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.