SOLVED

exel

%3CLINGO-SUB%20id%3D%22lingo-sub-1413559%22%20slang%3D%22en-US%22%3Eexel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1413559%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20would%20like%20the%20formulas%20to%20be%20able%20to%20do%20the%20following%20please%2C%20IF%20cell%20A1%20had%20P004%20input%20then%20cell%20B1%20would%20automatically%20have%20Wacker%20plate%20applied%20and%20cell%20C1%20would%20have%20001267%20applied%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1413559%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1413612%22%20slang%3D%22en-US%22%3ERE%3A%20exel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1413612%22%20slang%3D%22en-US%22%3EIn%20B1%3A%20%3DIF(A1%3D%22P004%22%2C%22Wacker%20plate%22%2C%22%22)%20In%20C1%3A%20%3DIF(A1%3D%22P004%22%2C%22001267%22%2C%22%22)%20That%20is%2C%20if%20I've%20understood%20correctly%20what%20you're%20asking...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1413645%22%20slang%3D%22en-US%22%3ERE%3A%20exel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1413645%22%20slang%3D%22en-US%22%3EMany%20thanks%20that%20is%20very%20helpful%2C%20is%20there%20a%20formula%20to%20link%20to%20a%20cell%20rather%20than%20a%20word%20as%20follows%2C%20%3DIF(A1%3D%22P004%22%2C%22Wacker%20plate%22%2C%22%22)%20instead%20of%20saying%20%E2%80%9Cwacker%20plate%E2%80%9D%20could%20it%20be%20linked%20to%20what%20it%20says%20in%20another%20cell%20like%20F1%20has%20the%20wacker%20plate%20in%20it%2C%20so%20the%20formula%20goes%20to%20that%20cell%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1413653%22%20slang%3D%22en-US%22%3ERE%3A%20exel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1413653%22%20slang%3D%22en-US%22%3EAbsolutely%20-%20just%20replace%20the%3A%20%22P004%22%3CBR%20%2F%3Ewith%3A%20F1%3CBR%20%2F%3E(or%20any%20other%20cell%20reference%20you'd%20need).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1413654%22%20slang%3D%22en-US%22%3ERE%3A%20exel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1413654%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F53759%22%20target%3D%22_blank%22%3E%40Austris%20Bahanovskis%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EMany%20thanks%20that%20is%20very%20helpful%2C%20is%20there%20a%20formula%20to%20link%20to%20a%20cell%20rather%20than%20a%20word%20as%20follows%2C%20%3DIF(A1%3D%22P004%22%2C%22Wacker%20plate%22%2C%22%22)%20instead%20of%20saying%20%E2%80%9Cwacker%20plate%E2%80%9D%20could%20it%20be%20linked%20to%20what%20it%20says%20in%20another%20cell%20like%20F1%20has%20the%20wacker%20plate%20in%20it%2C%20so%20the%20formula%20goes%20to%20that%20cell%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1413658%22%20slang%3D%22en-US%22%3ERE%3A%20exel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1413658%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F53759%22%20target%3D%22_blank%22%3E%40Austris%20Bahanovskis%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20obviously%20(me%20bad!)%20when%20I%20said%26nbsp%3B%3CSPAN%3E%22P004%22%20I%20meant%26nbsp%3B%22Wacker%20plate%22%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

i would like the formulas to be able to do the following please, IF cell A1 had P004 input then cell B1 would automatically have Wacker plate applied and cell C1 would have 001267 applied 

5 Replies
best response confirmed by Tony55 (New Contributor)
Solution
In B1: =IF(A1="P004","Wacker plate","") In C1: =IF(A1="P004","001267","") That is, if I've understood correctly what you're asking...
Many thanks that is very helpful, is there a formula to link to a cell rather than a word as follows, =IF(A1="P004","Wacker plate","") instead of saying “wacker plate” could it be linked to what it says in another cell like F1 has the wacker plate in it, so the formula goes to that cell
Absolutely - just replace the: "P004"
with: F1
(or any other cell reference you'd need).

@Austris Bahanovskis 

 

Many thanks that is very helpful, is there a formula to link to a cell rather than a word as follows, =IF(A1="P004","Wacker plate","") instead of saying “wacker plate” could it be linked to what it says in another cell like F1 has the wacker plate in it, so the formula goes to that cell

@Austris Bahanovskis 

And obviously (me bad!) when I said "P004" I meant "Wacker plate"