• 549K Members
• 8,495 Online
• 657K Conversations

New Contributor

# Help with excel - and working with the right Formula

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.

5 Replies
Highlighted

# Re: Help with excel - and working with the right Formula

Perhaps

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

if I understood your logic correctly

Highlighted

# Re: Help with excel - and working with the right Formula

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

# Re: Help with excel - and working with the right Formula

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

# Re: Help with excel - and working with the right Formula

Thanks Sergei,
I have managed to do that with the IF.

Highly appreciated.
Highlighted

# Re: Help with excel - and working with the right Formula

@Dotan-feldman , you are welcome

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