Chart needs to auto populate items from master referance chart based on job description.

Put this formula in K6:

=VLOOKUP($J6,$B$7:$E$9,MATCH(K$5,$B$6:$E$6,0),0)

then copy across and down.

Hope this helps.

Pete

With a new but not so smooth title.


Well, that worked real nice. Thanks. I really need to learn about this vlookup thing.

Thanks as always, and maybe i need to read the form rules... :]

Hi there.

I am trying to get the last bit here, and i can quite get it to work.

Please take a quick look at the sheet and let me know your thoughts. For some reason the cells aren't aligning properly. I need it on 2 different sheets, so the second sheet is the reference chart, the first sheet is the results.

Thanks

training.xlsx

In the MATCH part of the formula, you want the range to start with C6 in the referance sheet:

MATCH(E$5,referance!$C$6:$U$6,0)

so make that change in red and then you can copy the formula across and down as required.

Hope this helps.

Pete

One cell off, aahhhHHH.

Thanks.