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.
if I understood your logic correctly
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.
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>, "")
@Dotan-feldman , you are welcome