Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 ---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Function with VLOOKUP | Excel Worksheet Functions | |||
make a vlookup using a variable path | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
VLOOKUP not working | Excel Worksheet Functions |