I am making a form with drop down boxes and auto fill to make things easier.
I have one Box for the Company selection another box for the occupation selection and I need a formula to find a $ value based on the selections made in these two cells.
If I could establish the actual cell reference of the selected data in the second drop down list that would help but a full solution would be great.
The data will be much larger than this example and will live on a separate sheet.
Your help is much appreciated.
Bookmarks