Good morning everyone!
I have a workbook with 2 sheets. Current Tab is where I need the formula. Change things here Sheet is where to update information.
I have 3 locations in my sample. On the 'Current Tab' I am needing a formula for columns F - S, rows 10-13, rows 18-21 and rows 26 - 29. I have outlined these in red. Hopefully to make this easier. All of the blue cells should have an X if the formula is working. The other cells within the Red outlines should be blank.
The information is to come from Sheet 'change things here K3-X8 in my sample.
So for the formula I want to find the name on 'change things here J3:J8 that matches Current Tab B10:B29 and then populate Current Tab F - S, rows 10-13, rows 18-21 and rows 26 - 29, with what is adjacent to 'change things here J3:J8 in columns K-X
'Current Tab' F10:S11 have formulas I have tried but obviously don't work!
In short we have 50+ people that occasional change locations and when I make changes on 'change things here' B4:H6 I need the characteristics to follow the names.
I really hope this makes since. Please let me know if you need more clarification!
Thank you in advance all who look at my question!!
Bookmarks