Vlookup in data validation???
I have 2 workbooks, Masterlist and Report. The Masterlist has all the
employees names and what type of expense they work on (COGS or SGA). The Report has a data validation in column A so the user can choose the employee name. In column B the user also has to select what type of project the employee will be working on, I have a data validation on this cell as well (user selects from Cap, Exp or OT). If Exp is choosen I'd like the cell to go back to the Masterlist and bring back the type of expense (COGS or SGA). The user will not know what type of expense the employee has so they can't choose COGS or SGA. Is this possible? |
Vlookup in data validation???
You would have to have a separate cell for it, so column C would do a
VLOOKUP, such as: =if(b2="Exp",vlookup(name,masterlist!a1:z100,3,fal se),"") where name is the employee name, masterlist!a1:z100 is data on your master list, 3 is the column that would containg COGS or SGA, and false means exact match on the employee name. -- John C "ChrisP" wrote: I have 2 workbooks, Masterlist and Report. The Masterlist has all the employees names and what type of expense they work on (COGS or SGA). The Report has a data validation in column A so the user can choose the employee name. In column B the user also has to select what type of project the employee will be working on, I have a data validation on this cell as well (user selects from Cap, Exp or OT). If Exp is choosen I'd like the cell to go back to the Masterlist and bring back the type of expense (COGS or SGA). The user will not know what type of expense the employee has so they can't choose COGS or SGA. Is this possible? |
All times are GMT +1. The time now is 01:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com