Jan 21 2020 12:28 AM
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.
Jan 21 2020 06:05 AM
Perhaps
=INDEX($A$8:$A$12,MATCH($D$2,$A$2:$A$6,0))
if I understood your logic correctly
Jan 21 2020 10:20 AM - edited Jan 21 2020 11:04 AM
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.
Jan 21 2020 01:20 PM
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>, "")
Jan 22 2020 11:15 PM
Jan 23 2020 05:36 AM
@Dotan-feldman , you are welcome