Home

Help with excel - and working with the right Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1119311%22%20slang%3D%22en-US%22%3EHelp%20with%20excel%20-%20and%20working%20with%20the%20right%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1119311%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Experts%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20a%20newbie%20to%20Excel%20and%20have%20managed%20to%20do%20some%20formulas%20so%20far.%3C%2FP%3E%3CP%3EI%E2%80%99m%20trying%20to%20make%20some%20kind%20of%20a%20configurator%20that%20has%202%20columns%20of%20P%2FN%20%E2%80%93%20see%20attached%20excel.%3C%2FP%3E%3CP%3ED2%20%E2%80%93%20is%20a%20dropdown%20list%20of%20the%20SKU's%20in%20A2%3AA6%3C%2FP%3E%3CP%3ED3%20%E2%80%93%20Show%20with%20vLookUp%20the%20P%2FN%20associated%20with%20D2%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%E2%80%99m%20trying%20to%20condition%20that%20the%20yellow%20in%20D9%20will%20show%20only%20the%20relevant%20SKU%20that%20is%20chosen%20in%20D2%20but%20from%20A8%3AA12%3C%2FP%3E%3CP%3Efor%20example%3A%20If%20I%20choose%20A2%20then%20only%20SKU%20in%20A8%20will%20be%20shown%20in%20the%20yellow%20section.%3C%2FP%3E%3CP%3EA3%20then%20only%20SKU%20in%20A9%20will%20be%20shown%20and%20so%20on.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20appreciate%20your%20assistance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1119311%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1119972%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20excel%20-%20and%20working%20with%20the%20right%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1119972%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F526558%22%20target%3D%22_blank%22%3E%40Dotan-feldman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DINDEX(%24A%248%3A%24A%2412%2CMATCH(%24D%242%2C%24A%242%3A%24A%246%2C0))%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Eif%20I%20understood%20your%20logic%20correctly%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1120708%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20excel%20-%20and%20working%20with%20the%20right%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1120708%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethat%20is%20almost%20right.%3C%2FP%3E%3CP%3Ei%20need%20that%20in%20the%20section%20will%20be%20as%20option%20to%20choose%20from%202%20choices%3A%3C%2FP%3E%3CP%3E1.%20empty%20-%20it%20no%20second%20SKU%20is%20needed.%3C%2FP%3E%3CP%3E2.%20to%20fill%20the%20formula%20that%20you%20addressed%20me%20to.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1124283%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20excel%20-%20and%20working%20with%20the%20right%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1124283%22%20slang%3D%22en-US%22%3EThanks%20Sergei%2C%3CBR%20%2F%3EI%20have%20managed%20to%20do%20that%20with%20the%20IF.%3CBR%20%2F%3E%3CBR%20%2F%3EHighly%20appreciated.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1121145%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20excel%20-%20and%20working%20with%20the%20right%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1121145%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F526558%22%20target%3D%22_blank%22%3E%40Dotan-feldman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20have%20to%20instruct%20Excel%20somehow%20which%20option%20to%20select.%20That%2C%20for%20example%2C%20could%20be%20a%20value%20in%20some%20cell.%20Resulting%20formula%20will%20be%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DIF(C1%3D%22need%20second%20SKU%22%2C%20%3CINITIAL%20formula%3D%22%22%20for%3D%22%22%20second%3D%22%22%20sku%3D%22%22%3E%2C%20%22%22)%3C%2FINITIAL%3E%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Dotan-feldman
New Contributor

Hi Experts,

 

I'm a newbie to Excel and have managed to do some formulas so far.

I’m trying to make some kind of a configurator that has 2 columns of P/N – see attached excel.

D2 – is a dropdown list of the SKU's in A2:A6

D3 – Show with vLookUp the P/N associated with D2

 

I’m trying to condition that the yellow in D9 will show only the relevant SKU that is chosen in D2 but from A8:A12

for example: If I choose A2 then only SKU in A8 will be shown in the yellow section.

A3 then only SKU in A9 will be shown and so on.

 

Would appreciate your assistance.

 

 

5 Replies
Highlighted

@Dotan-feldman 

Perhaps

=INDEX($A$8:$A$12,MATCH($D$2,$A$2:$A$6,0))

if I understood your logic correctly

Highlighted

@Sergei Baklan 

 

Thanks!

 

that is almost right.

i need that in the section will be as option to choose from 2 choices:

1. empty - it no second SKU is needed.

2. to fill the formula that you addressed me to.

 

Thanks again.

 

Highlighted

@Dotan-feldman 

We have to instruct Excel somehow which option to select. That, for example, could be a value in some cell. Resulting formula will be like

=IF(C1="need second SKU", <initial formula for second SKU>, "")
Highlighted
Thanks Sergei,
I have managed to do that with the IF.

Highly appreciated.
Highlighted
Related Conversations
Hide error strings
JoeRock in Excel on
1 Replies
setting up multiple web queries
stringer47 in Excel on
0 Replies
Look up
Mano_96 in Excel on
1 Replies
Changing the range of numers on an axis
Stuonblue in Excel on
0 Replies
Changer la police par défaut
JacquesBe in Excel on
0 Replies
Issue with protections on a table - Excel
James2025 in Excel on
1 Replies