If(or(

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
 
G

Guest

Nested if should work...
If(a3=" ","EnterProject Number",If(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))))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup 1
Help with Nested IF Statements 4
If/Vlookup override 4
VLOOKUP with a blank cell 5
Date - Help 7
Help with an IF Formula 5
#N/A = FALSE 1
Problem with IF condition or vector lookup? 4

Top