0

I have 2 sheets with the same columns with integer values. In sheet A I have a drop down list of the names in sheet B. Based on what drop down I have selected, I'd like to add the values of sheet B to sheet A.

For example:

Sheet A has John with values 5,6,-3 in each column. In Sheet B has Baker with values -1,9,4 and Police with 8,3,-2. If the drop down in A has Baker, I want values in Johns row on A be 4,15,1, if its Police then it should be 13,9,-5, etc.

Every person can select a different job, they are not restricted to just using one selection for everyone. After that is done I'd like to add data validation so John can only pick certain jobs, i.e. prevent him from selecting a value in B called Pilot with it's own set of numbers.

I figure I would have to use VLOOKUP but I'm unsure how to integrate it into a whole row function with SUM and a drop down.

Sheet here

  • Welcome to Webapps. Please share a sample sheet including desired result. – marikamitsos Aug 11 at 23:33
  • I'm not sure what do you mean by including a sample sheet. Idk how to get the result I want which is why I'm asking. – AndroidDragon Aug 12 at 4:14
  • "... what do you mean by including a sample sheet. Idk how to get the result I want which is why I'm asking." Something like this or this – marikamitsos Aug 13 at 12:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.