I am trying to re-learn excel after a long illness and I have come against a problem.
I have tried the answers I thought might work, but I must be doing something wrong.
I have a formula that works
=INDEX(Sharp!$B$2:$N$212,MATCH($D$3,Sharp!$A$2:$A$212,0),1)
I need to replace the 2 sheet names (Sharp) with the name that appears in cell B3.
This cell (B3) uses a dropdown box to choose the manufactures name and I have each sheet labelled with the manufactures name.
So, when I change the name in cell B3 using the dropdown I want the formula to use that sheet name.
I am using Excel 365 and Win10.
Sorry, if I haven't explained this very well but I'm still re-learning excel. Thanks in advance.
Bookmarks