FORMULA
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 blank if the answer is false.
can someone show me what I am doing wrong.
Sheet1
Sheet 2
=IF(ISNUMBER(SEARCH(“S/L”,Q2)),XLOOKUP($S2,Sheet2!A:A,Sheet2!B:B))
The formula is in the sideloader cells, it is looking for s/l in the trailer cells and if true it then looks to see what is in the name pick up cell and matches the name on sheet 2 and if true puts the price in..
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 blank if the answer is false. can someone show me what I am doing wrong.Sheet1Sheet 2=IF(ISNUMBER(SEARCH(“S/L”,Q2)),XLOOKUP($S2,Sheet2!A:A,Sheet2!B:B)) The formula is in the sideloader cells, it is looking for s/l in the trailer cells and if true it then looks to see what is in the name pick up cell and matches the name on sheet 2 and if true puts the price in.. Read More