Hello,
I have a table of data on a worksheet labeled Information. The table has three columns, Y2:Y29 is employee names, Z2:Z29 is equipment and AA2:AA29 is code number (six digits). On another worksheet labeled Form I have validation lists in cells C26 and C28. C26 is the employee name validation list and C28 is the equipment list. I would like to have the code number from Information sheet placed in cell C30 when the employee name and equipment used is selected. Also cells C26, C28, and C30 are merged, don't know if that is causing problems with some of the formulas I have tried or not.
Any help would be greatly appreciated, Thanks.
I have a table of data on a worksheet labeled Information. The table has three columns, Y2:Y29 is employee names, Z2:Z29 is equipment and AA2:AA29 is code number (six digits). On another worksheet labeled Form I have validation lists in cells C26 and C28. C26 is the employee name validation list and C28 is the equipment list. I would like to have the code number from Information sheet placed in cell C30 when the employee name and equipment used is selected. Also cells C26, C28, and C30 are merged, don't know if that is causing problems with some of the formulas I have tried or not.
Any help would be greatly appreciated, Thanks.