This isn't working, i still need to set the range i think.

I can't figure out how to set the range and returned cell when looking for
two specific values. so it would only return a value ONLY when A1 and B1 were
correct and otherwise to return 0.

A1 is a date, could this be causing the problem? I have checked that the
sheet the lookup is referencing is in the same format etc.


"SamuelT" wrote:

>
> You could try adding an IF/AND formula at the start:
>
> =IF(AND(B1=23, C1=250),VLOOKUP(whatever, whatever, whatever, FALSE),
> "")
>
> SamuelT
>
>
> --
> SamuelT
> ------------------------------------------------------------------------
> SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
> View this thread: http://www.excelforum.com/showthread...hreadid=547066
>
>