Peter,

Try this:

=IF(NOT(ISNA(VLOOKUP(I14,Paid!A:B,2,FALSE))),VLOOK UP(I14,Paid!A:B,2,FALSE),IF(LEFT(T14,8)="Promised" ,2,IF($K14<1,5,3)))

HTH,
Bernie
MS Excel MVP


"Peter" wrote in message
...
Hi all

I have the following formula

=IF(ISNA(VLOOKUP(I14,Paid!A:B,2,FALSE)),IF($K14<1, 5,3),(VLOOKUP(I14,Paid!A:B,2,FALSE)))

This is used to check if invoice no is on paid sheet then enter 1, if not
then depending on age of invoice (column K) then either 5 or 3.

I need to add another if function - =if(left(T14,8)"Promised",2 - this is
to
show payments due -
=if(left(T14,8)"Promised",2,IF(ISNA(VLOOKUP(I14,Pa id!A:B,2,FALSE)),IF($K14<1,5,3),(VLOOKUP(I14,Paid! A:B,2,FALSE))))

Conflicts when invoice is paid and invoice No appears on paid sheet -
still
remains as 2.

Order of checking should be: - check if paid if yes then 1 - if no then
check if promised, if yes then 2, if no then check age, 5 if <1 3 if1.

Any ideas? or if not best explained please let me know