Auto populate cells dependant on multiple inputs

[Jason N]

Good morning all,

I have been struggling with sorting out how to auto populate 3 cells based upon the input of two. I have spent a fair amount of time to try and get this work to no avail. Any assistance would be greatly appreciated.

Essentially what I am looking to do is have the valid for, Expiry Date, and Cost auto populate by the selections made in Type of Training and Training Provided by.

I have tried using VLOOKUP and the DATE functions but have been struggling to get these accurate.

-----
The Data Sheet
- Type of Training is manually entered
- Provider is selected from the Training Providers Table (Separate table to reduce multiple copies of prover in a data validation)
- Cost is manually entered
- Valid for is manually entered.
- Training Providers is Manually Entered


Thanks again for any assistance or guidance.

[sourabhg98]

Cell G3 (copied down) -

Please Login or Register  to view this content.

Cell I3 (copied down) -

Please Login or Register  to view this content.

[Jason N]

Thanks for the help Sour. This is definitely above my experience! One Day...

Thanks again!

[sourabhg98]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

[Jason N]

I've already added the reputation.

It fixes my issues, partly.

It seems that in the data table the code does not auto populate on the addition of a new row. Based on my research it appears it could potentially be due to lack of absolute references?

Any assistance would be super helpful.

[sourabhg98]

Follow these steps -

1. Copy the formula to all rows of the table.
2. Select any cell on the table, go to 'Design' tab and click 'Convert to Range'
3. Now, select all the cells of the table.
4. Go back to 'Home' tab and select 'Format as Table' > select your table theme.

Reformatting it as table should enable the auto-fill functionality at the backend, so now if you enter a new row it would auto-fill formulas.

[Jason N]

Perfect thanks! It's fully functional!

I will close the Post.

Thanks again!