Auto Populate Project Number based on Indirect Formulas

[RyanI1986]

Backstory:
I have two companys that I am trying to merge into shift tracking system. We have over 200-300 clients and 500-600 projects per year. The file only shows 2 clients

I made this work one way where I had two master lists of projects based on company names and the cell values for client, project, client project number, internal project number all worked fine. However the project list was so long that it would be faster to just type the project name, or copy and paste from the list vs using the data validation.

I am trying to get the Client to populate based on Company, then Project to data validate based on client, then client project number and internal project number to auto populate based on project name. I made it work with a single list using the index match functions, however my data validation list of project is so long, it would be faster to just type the name of the project rather than pick from a data validation list.

File located here:

WCIS-USIC Shift Schedule 2023 Test 2.xlsx

Shared with Dropbox

www.dropbox.com

 

[fjns]

Hi, try the next formulas on worksheet Field_Shift_Schedule
for G4
=INDEX('AUTOPOULATED PROJECT NUMBERS'!B3:B99,MATCH(F4,'AUTOPOULATED PROJECT NUMBERS'!A3:A99,0))
for H4
=INDEX('AUTOPOULATED PROJECT NUMBERS'!C3:C99,MATCH(F4,'AUTOPOULATED PROJECT NUMBERS'!A3:A99,0))

 

[RyanI1986]

That works. Thank you.