Hello,
I am here looking for advice as to what the best thing to do with my problem.
The problem itself is that I have a drop down box with a large list of companies.
The requirement is that when one of these companies is selected the company information will appear in a couple of other cells below that drop down box. The data is in another workbook. I looked at an IF function that said if this company is in the box then display its information in this cell, but I can't put more than seven nested if statements in one cell.
So my question is this a VBA solvable problem or is there another function I can use?
Thanks you
Bookmarks