Hi,

This is what i have so far as small part of a macro - it should work as a normal formula also which is how i am testing it:

=IF(ISNA(VLOOKUP(C2,Pipeline!$B$4:$J$200,9,FALSE)),"",(VLOOKUP(C2,Pipeline!$B$4:$J$2001,9,FALSE)))

It looks up to see whether a company in C2 has an end date for a delivery. What i would like is to have the next available working date - not just the exact end date from the vlookup.

The other thing that doesn't work is the range name - which works in another vlookup formula i have - and i can't see why it wouldn't.

eg: =IF(ISNA(VLOOKUP(B4,Data,2,FALSE)),"",VLOOKUP(B4,Data,2,FALSE))

Please - does anyone have any ideas?

thanks