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


--
moglione1
------------------------------------------------------------------------
moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414
View this thread: http://www.excelforum.com/showthread...hreadid=520610

Vlookup 'And' statement
 

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(B26,C2<4),"Y","N")

Andy.

"moglione1" wrote
in message ...

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