did you try putting the IF statement first :
=IF('Entry 1 - New Clients'!N2="ACTIVE",VLOOKUP('Entry 1 - New
Clients'!A2,'Entry 1 - New Clients'!A2:O20,3,FALSE)),"")

Is this what you were trying to achieve ?

Fadi

On Thu, 10 Mar 2005 20:55:02 -0800,
wrote:

Received the following reply to earlier question (below).
Doesn't work. Can the above two statements be combined?
Ie. If one cell (in another worksheet) = "Active" then
lookup the values from the same worksheet.

I've been trying:
VLOOKUP(IF('Entry 1 - New Clients'!N2:N31="ACTIVE",'Entry
1 - New Clients'!A2,'Entry 1 - New Clients'!
A2:O20,2,FALSE))

Returns ugly errors. Maybe Excel doesn't like the
combination of both statements?


Yes, just re-use the formula in another cell with a
different column index

=VLOOKUP('Entry 1 - New Clients'!A2,'Entry 1 - New
Clients'!A2:O20,3,FALSE).

note the ,3 not ,2