Forum Discussion
Excel IF help
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
- jh1979Sep 25, 2019Copper Contributor
Please ignore previous messages, i have figured it out. Many thanks
- jh1979Sep 25, 2019Copper Contributor
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
- SergeiBaklanSep 25, 2019Diamond Contributor
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)
- jh1979Sep 27, 2019Copper Contributor
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.
- jh1979Sep 25, 2019Copper Contributor
can i add more options to this formula? i would like 4 or 5 options in there. currently there are 2SergeiBaklan
- jh1979Sep 25, 2019Copper Contributor
thanks this now works - i think i'd actually made an error in my typing. But thanks for your help - SergeiBaklan