IF formula

[Ziro54]

Hi hope someone can help?

I looked at other posts, see similar requests but not exact. Please assist if you can.

Tab 1 - Training Requirements

Column B Row5 Designation (E.G. Project Director, Site Agent etc.)

Column C Row5 Legal Appointment (E.G 16.2, 6.1 etc.)

Column D:BE Represent several different training requirements


Where the represented designation align with the required training, it will only be marked with "x".

Tab 2 - Training Matrix

Column B - Surnames
Column C - Names
Column D - Designation
Column E - Legal Appointment
Column F:BG is a copy of the training on Tab 1 (D:BE)

When the Designation in Tab 2 is entered i want the cells marked x on Tab 1 to be copied to Tab 2 in an exact match to represent the required training for that specific designation.

I have a macro in Tab 2 that sorts the sheet according to surname.

I am sure there will be a macro that can do this with ease other than using "IF" formula. If so, I'd like the macro to auto update as the information is entered.

All the help will be appreciated.


Thanks.

 

[Matty]

Welcome to MrExcel!

Could you post a sample of the Worksheets so that we can easily test possible solutions?

Matty

 

[Ziro54]

Cant seem to find a way to upload an example? Do i have to upload and provide a link?

Sorry new to this site.

 

[Ziro54]

Here is a link to the sample. It is not complete. Before i spend too much time on it, I want to make sure it works.
Example.xlsm

Thanks

 

[Matty]

Looks like a basic matrix lookup formula will do what you need.

But where do you want the Xs on the Training Matrix Worksheet to go?

Matty

 

[Ziro54]

Looks like a basic matrix lookup formula will do what you need.

But where do you want the Xs on the Training Matrix Worksheet to go?

Matty

Morning Matty

Initially the whole 'Training Matrix' Tab 2 will be empty. I actually considering moving the formula columns on the training matrix to the reference sheet. so the x can go where the dates are entered. Because the first information that will be recorded is the basics, name, surname, designation.

So initially the x will be where the date is now as an example. Then when the person attends the training, the x will be replaced with a date.

Thank you.