Forum Discussion

jh1979

Copper Contributor

Sep 24, 2019

Excel IF help

i am creating an excel sheet to try and show a basic configurator. i have the following which shows that if copier desk is selected in call F9 then the cell will read DK-510 Copier desk. =IF(F9="Cop...

IF command

SergeiBaklan

Diamond Contributor

Sep 24, 2019

jh1979

If replace doubled single apostrophes on double apostrophes the formula works

=IF(F9="Copier desk", "DK-510 Copier desk", IF(F9="500 Sheet tray","PF-514"))

But I'm not sure when that was introduced, typing the post or in Excel

jh1979

Copper Contributor

Sep 25, 2019

This for example - =IF(F9="Copier desk", "DK-510 Copier desk", IF(F9="500 Sheet paper feed cabinet","PF-514", if(f9= ''TWO 500 Sheet paper feed cabinet'',''PC-512''))) - but this doesnt workSergeiBaklan

SergeiBaklan
Diamond Contributor
Sep 25, 2019
jh1979

Okay, so far so good. As a comment, better not to hardcode your texts into the formulas, but put the in some helper range, like

With that your formula could be transformed to

=LOOKUP(F9,$B$1:$B$10,$C$1:$C$10)
- jh1979
  Copper Contributor
  Sep 27, 2019
  SergeiBaklan sorry from the last message - i would like to add items from sheet 2 to the top of sheet 4 if nothing selected from sheet 1.
  - SergeiBaklan
    Diamond Contributor
    Sep 27, 2019
    jh1979
    
    Sorry, but I didn't catch. Could you please provide small sample to illustrate the task.