Thursday, February 20, 2014

yogi_Pull Row By Row For Each Job Name Associated Job ID From A Table In Another Sheet

                                         Google Spreadsheet   Post  #1539
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-20-2014
post by masterCraft Kitchen & Bath (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/Hlx_kH6vJnM)
Find values based on a filtered list of values
I have a sheet "Time Sheet" where an employee will select a Job Name from a drop down list that is populated from another sheet "Current Jobs". Column A is a list of Job Name and column B lists Job ID in "Current Jobs". I have a column Job ID in "Time Sheets" that I want to be populated from "Current Jobs" based on the selection of the Job Name. I am using validation for the Job Name which works fine but can't figure out a way to populate the Job ID based on the selection. I am using the formula =ArrayFormula(if(G11:G="","",vlookup(G11:G,CurrentJobs!A:B,1*row(G11:G)^0,0))) in H11 - G11 is the dropdown where the Job Name is selected. With this formula H11 is being populated with the Job Name instead of Job ID. Not sure what I am doing wrong...
Thanks in advance for any help.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

formula in sheet PP1-14