BRUCE6466Copper ContributorMay 22, 2024FORMULA I am trying to have a price enter automatically in a spreadsheet, (Z2). The formula appears to work when it is true, but when it is false it brings up the word false, I would like the cell to be ...Show More
Harun24HRSilver ContributorMay 22, 2024BRUCE6466 Simply use false part of IF() function. Use an empty string to show it as blank. Try-=IF(ISNUMBER(SEARCH("S/L",Q2)),XLOOKUP($S2,Sheet2!A:A,Sheet2!B:B),"")
BRUCE6466Copper Contributor to Harun24HRMay 25, 2024I am not sure where in the formula to put it (false), I had tried entering in several positions
