Help with excel - and working with the right Formula

Copper 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

@Dotan-feldman 

Perhaps

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

if I understood your logic correctly

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

 

@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>, "")
Thanks Sergei,
I have managed to do that with the IF.

Highly appreciated.