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.