IF and VLOOKUP
 

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.

Try something along the lines of:

=IF(M4=1,0,IF(M4="",IF(ISNA(VLOOKUP(...)),"",VLOOK UP(...)),"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 <atyahoo<dotcom
----
"Micayla Bergen" wrote in message
...
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.

Typo:

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----