W
Walshy
Hi there I have a formaul but wish to put an Or statement
within it can you please help ?
My current formula is :
=IF(ISERROR(VLOOKUP($A13,'[File.xls]Budget Monitoring'!
$A$1:$AO$351,2,FALSE)),"Wrong project number",(VLOOKUP
($A13,'[File.xls]Budget Monitoring'!$A$1:$AO$351,2,FALSE)))
I want to put an or statement (I think) before this so
that if cell a13 is blank then saying "Enter Project
Number" or (if not blank) doing the above formula ???
Thanks for your help
within it can you please help ?
My current formula is :
=IF(ISERROR(VLOOKUP($A13,'[File.xls]Budget Monitoring'!
$A$1:$AO$351,2,FALSE)),"Wrong project number",(VLOOKUP
($A13,'[File.xls]Budget Monitoring'!$A$1:$AO$351,2,FALSE)))
I want to put an or statement (I think) before this so
that if cell a13 is blank then saying "Enter Project
Number" or (if not blank) doing the above formula ???
Thanks for your help