IF and VLOOKUP

[Guest]

i have a vlookup function in N4, if the value in M4 = 1 i want N4 to return a
o, but if M4 is blank i want to use the vlookup formula
any takers???
Many thanks to everyone who has helped w this nightmarish spreadsheet of mine.

 

[Max]

Try something along the lines of:

=IF(M4=1,0,IF(M4="",IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...)),"M4 is neither 1
nor 0"))

You can replace the phrase: "M4 is neither 1 nor 0"
with something else (you didn't specify this)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----

i have a vlookup function in N4, if the value in M4 = 1 i want N4 to return a
o, but if M4 is blank i want to use the vlookup formula
any takers???
Many thanks to everyone who has helped w this nightmarish spreadsheet of

mine.

 

[Max]

Typo:

"M4 is neither 1 nor 0"
should read as: "M4 is neither 1 nor blank"