Forum Discussion

BRUCE6466's avatar
BRUCE6466
Copper Contributor
May 23, 2024

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..

 

 

Excel
Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    May 23, 2024

    BRUCE6466 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),"")
    • BRUCE6466's avatar
      BRUCE6466
      Copper Contributor
      May 26, 2024
      I am not sure where in the formula to put it (false), I had tried entering in several positions

Share

Resources