bujaman
03-30-2009, 10:04 PM
Ok,
I have an excel file with multiple worksheets, each with a table with different prices based on measurements. The row and column headings are the measurements. On the last sheet I have a drop-down box that lists the names of the worksheets for the user to select. On that last sheet there is a place where the person using the sheet can enter the measurements they take, and I want the sheet to take the measurements they enter, and the drop-down item they select, and pull the correct value from the correct worksheet. I have been trying to do it with index and match in the worksheet itself, but that gets messy. vlookup doesn't seem to work, either. I have attached what I have so far for your perusal. Any help would be greatly appreciated. Thanks!
I have an excel file with multiple worksheets, each with a table with different prices based on measurements. The row and column headings are the measurements. On the last sheet I have a drop-down box that lists the names of the worksheets for the user to select. On that last sheet there is a place where the person using the sheet can enter the measurements they take, and I want the sheet to take the measurements they enter, and the drop-down item they select, and pull the correct value from the correct worksheet. I have been trying to do it with index and match in the worksheet itself, but that gets messy. vlookup doesn't seem to work, either. I have attached what I have so far for your perusal. Any help would be greatly appreciated. Thanks!