Hi,
probably a simple answer but i haven't come across it on here...
im trying to get the lookup answer based on two values the current formula i have is
Quote
=VLOOKUP(AND(A1,B1),Sheet2!$A$1:$C$31,3,FALSE)
which naturally returns N/A... i might even be using the wrong formula?
any help much appreciated
z